SELECT fields with igoring zero before strings

bono56 · #1 (**permalink**) 10-15-07, 08:28

hi
i want to write a select query which ignore zeros before the string.
for example if fld1='007Sh980', my query must return '7Sh980'.
anyone can help?

gvee · #2 (**permalink**) 10-15-07, 09:20

EDIT: Actually, this is wrong, so ignore it

bono56 · #3 (**permalink**) 10-15-07, 15:35

is it possible with mysql function? if it is, plz recommend best func for this

r937 · #4 (**permalink**) 10-15-07, 15:49

SELECT TRIM(LEADING '0' FROM fld1) as trimmed_fld1 ...

ortho · #5 (**permalink**) 10-16-07, 16:25

Wow interesting I didn't know that use of TRIM.
Thank you, I'll use that functionality for sure!

Internet Services

Web Development

Digital Marketing

Consumer Tech