Viewing post 1 (of 1 total)
declare@var1varchar(10)
SELECT@var1 = '1105231'
selectSUBSTRinG(@var1,PATINDEX('%[1-9]%',@var1),LEN(@var1)-PATINDEX('%[1-9]%',@var1)+1)
August 29, 2003 at 6:09 am
#471961