So you are storing a numeric value in aa string/text/char column... never a amart call to be honest
To find all rows with a leading zero you could use
The left function
Or the substr function
Or the like preedicate
Or for overkill (and bonus marks) regular expressions
Or you coul redesign the table and store the text as a number.
Having found tge means to select rows with leading zeros yhen apply that where clause in an update query. Ferinstance :-
...but youd have to run the query several times if say you had several rows with more than one leading zero.
update mytable set mycolumn = right (mycolumn,length (mycolumn) - 1)
Where left(mycolumn,1) = '0'
A far better solution is to change the underlying datatype of the column. But if you do decide to do this then do an imoact analysis BEFORE making changes. Ie what else needs changing eg screens, reports, queries. Cirrecting bad table design is more painful the longer you keave the problem to fester
I'd rather be riding on the Tiger 800 or the Norton