I need an update query that will strip leading zero if it exists at the beginning of a string..
The total string should be 9 characters.
Sometimes I have a people putting a leading zero.
it needs to be
need to be