[bono56]

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?

[georgev]

EDIT: Actually, this is wrong, so ignore it

[bono56]

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

[r937]

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

[ortho]

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