Stripping first 2 characters from a field 1

[brendalanigan]

Hi,

I am using an Access 97 database and I have been asked to tidy one of the fields by removing the first 2 characters in the field if they are numeric. This is lightly beyond my limited sql expertise - is there any easy way to do this?

Many thanks.

 

[Sumitdev]

Could try:

UPDATE Table1 Set Field1 = iif(IsNumeric(Left(Field1, 2)), Mid(Field1, 3), Field1)

 

[brendalanigan]

Many thanks for that - I will give it a try