how to trim leading zeros from alphanumeric text in mysql function

Question

What mysql functions are there (if any) to trim leading zeros from an alphanumeric text field?

Field with value "00345ABC" would need to return "345ABC".

Answer 1

You are looking for the trim() function.

Alright, here is your example

SELECT TRIM(LEADING '0' FROM myfield) FROM table

Answer 2

I believe you'd be best off with this:

SELECT TRIM(LEADING '0' FROM myField)

Answer 3

How can we add preceding zeros to VARCHAR value 0000000008

Answer 4

simply perfect:

SELECT TRIM(LEADING '0' FROM myfield) FROM table