How remove same 1st letter from many records?

[Ian Elliott]

Thanks in advance.
I have a one field query that has records like:
VN1200003
VN1200005
....
VN1988499
I would like to get rid of the 'V' from each record.
All help appreciated!
Thanks again.

 

[Danny J. Lesandrini]

Update MyTable Set [MyField] = Mid([MyField],2)
Where Left([MyField],1) = "V"

--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast


"Ian Elliott" wrote ...

 

[Dave]

you could use something like this

varsql = "UPDATE TABLE SET FIELD = Right(FIELD,Len(Field)-1)