Does anyone know if how to Trim alpha-numeric characters from the left of a returned recordset?

Eg

The recordset returns the string '1GK' but I only want to show 'GK' on the webpage.

Thanks

I don't get it. You want to trim alpha-numeric? That means you'll lose all ALPHA-bets and NUMERIC (numbers) and be left with nothing.....

am I missing something?

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I don't get it. You want to trim alpha-numeric? That means you'll lose all ALPHA-bets and NUMERIC (numbers) and be left with nothing.....

am I missing something?

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Use a Nested replace statement

Replace (StringtoSearch,StringtoFind,StringtoReplaceWith)
Replace (SampleCode, 1, '')
Replace (SampleCode, 2, '')

Well you get the idea

Now do that for every possible number...
Wait I have this same problem....



Carolus Holman