how to trim leading zeros from alphanumeric text in mysql function -


what mysql functions there (if any) trim leading zeros alphanumeric text field?

field value "00345abc" need return "345abc".

you looking trim() function.

alright, here example

select trim(leading '0' myfield) table 

Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -