I have a column that always has 12 characters. The values can vary with how many leading letters and zeros they have.
Is there a way to TRIM LEADING '0' OR 'A' OR 'B' OR 'C' etc.?
The easiest way to get what you want is probably a regular expression, find the first digit which is not a zero: