var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SELECT fields with igoring zero before strings
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?
EDIT: Actually, this is wrong, so ignore it
is it possible with mysql function? if it is, plz recommend best func for this
SELECT TRIM(LEADING '0' FROM fld1) as trimmed_fld1 ...
Wow interesting I didn't know that use of TRIM.
Thank you, I'll use that functionality for sure!