remove prepadded zeroes

Question

How can I remove prepadded zeroes from the Column below, Please suggest

[Column 0]
0001323
00000023232
0000432332
0000000053232
00332
000455

Answer 1

Try

select substring(ColumnName, patindex('%[^0]%',ColumnName), 10) 
From <table>

 

Answer 2

another way

SELECT REPLACE(LTRIM(REPLACE(ColumnName, '0', ' ')), ' ', '0')
From <table>

Answer 3

Try:

select
    c1,
    cast(cast(c1 as int) as varchar(25)),
    right(c1, len(c1) - (patindex('%[1-9]%', c1) - 1))
from
    (
    values
        ('0001323'),
        ('00000023232'),
        ('0000432332'),
        ('0000000053232'),
        ('00332'),
        ('000455')
    ) as T(c1);

 

---

AMB

Some guidelines for posting questions...