Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Remove Leading Zeros

    declare@var1varchar(10)

    SELECT@var1 = '1105231'

    selectSUBSTRinG(@var1,PATINDEX('%[1-9]%',@var1),LEN(@var1)-PATINDEX('%[1-9]%',@var1)+1)

Viewing post 1 (of 1 total)