how to trim or remove specific characters from start of string

Question

If I have codes stored in sql server database that look something like the following.

000001234560
000012345670
000000123450

How Can i remove all leading zeroes from the start of each code leaving me with

1234560
12345670
123450

Thank you

Its will help you https://stackoverflow.com/questions/4662496/trim-left-characters-in-sql-server — ErasmoOliveira, Mar 03 '15 at 13:36
possible duplicate of [Removing leading zeroes from a field in a SQL statement](http://stackoverflow.com/questions/92093/removing-leading-zeroes-from-a-field-in-a-sql-statement) — jpw, Mar 03 '15 at 13:37

score 1 · Answer 1 · answered Mar 03 '15 at 13:34

1

Convert the strings to numbers:

SELECT CONVERT(INT, YourColumn)
FROM YourTable

answered Mar 03 '15 at 13:34

Tom

score -1 · Answer 2 · edited May 23 '17 at 11:44

-1

Found the answer through another stackoverflow query here

The code that worked for me was

 SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))

Thanks for your help

edited May 23 '17 at 11:44

Community

answered Mar 03 '15 at 13:39

psycho

As your question is a duplicate of the other, don't post the answer from the other question here. there's no need as this question will be closed as a duplicate soon enough. – jpw Mar 03 '15 at 16:26

2 Answers2