This is a discussion on "ASP code to remove all letters except the first" within the Classic ASP section. This forum, and the thread "ASP code to remove all letters except the first are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
ASP code to remove all letters except the first
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
#1
|
|||
|
|||
|
Does anyone know any ASP code that would remove all letters except for the first letter of the results from a DB list result.
|
|
|
|
#2
|
|||
|
|||
|
Re: ASP code to remove all letters except the first
moved to asp forum
|
|
#3
|
|||
|
|||
|
Re: ASP code to remove all letters except the first
Well you could loop the recordset and do left(rs(0), 1) on each one.
Or you could just do it in the SQL so the recordset only returns the first letter. Unless there's some extenuating circumstance I would do it in the SQL. |
|
#4
|
|||
|
|||
|
Re: ASP code to remove all letters except the first
... as SELECT [MyFirstChar] = LEFT(myColName, 1) FROM table
|
![]() |
| Tags |
| asp, code, remove, letters, except, first |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to remove frames | camarun20 | Web Page Design | 6 | Mar 26th, 2008 14:11 |
| Remove white from around edges? | rxsid | Graphics and 3D | 7 | Dec 13th, 2006 09:57 |
| Remove UL spacing problem | relph2 | Web Page Design | 3 | Jan 3rd, 2006 17:22 |
| remove redirection | expressweb | Implemented Suggestions | 6 | Jul 21st, 2005 22:24 |
| Remove page number | malambing57 | Classic ASP | 1 | Oct 14th, 2004 08:47 |