Tuesday, 2 October 2007

Remove leading and trailing zeros from a numeric string

declare @str nvarchar(10)

set @str = '00101abc2300'

select replace(ltrim(rtrim(replace(@str, '0', ' '))), ' ', '0')
at

1 comment:

  1. aslam3 October 2007 at 08:20

    to remove only 'O' from left side only use:

    select replace(ltrim(replace(@str, '0', ' ')), ' ', '0')

    ReplyDelete