Trim leading 0s from string in T-Sql

Question

Possible Duplicate:
Removing leading zeroes from a field in a SQL statement

In a SQL Server 2008 database I have a string column which I need to select with the leading "0"s removed. E.g. 0023AFF should be returned as 23AFF. Is this possible in T-Sql and how?

See this Stack Overflow post: http://stackoverflow.com/questions/92093/removing-leading-zeroes-from-a-field-in-a-sql-statement — Aziz Shaikh, Nov 22 '12 at 11:56

score 4 · Accepted Answer · answered Nov 22 '12 at 11:59

4

Use PatIndex

declare @s varchar(20)='0023aff'

select substring(@s,PATINDEX('%[^0]%',@s),LEN(@s))

answered Nov 22 '12 at 11:59

podiluska

50,950
7
98
104

Trim leading 0s from string in T-Sql

1 Answers1