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

<p>Field with value "00345ABC" would need to return "345ABC".</p>

You are looking for the
trim() function
.
Alright, here is your example
```
```
SELECT TRIM(LEADING '0' FROM myfield) FROM table
```
```