.net resources: Remove leading and trailing zeros from a numeric string

Tuesday, 2 October 2007

declare @str nvarchar(10)

set @str = '00101abc2300'

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

aslam said...: to remove only 'O' from left side only use:

select replace(ltrim(replace(@str, '0', ' ')), ' ', '0'); 3 October 2007 at 08:20