Update Query Help

C

Cheyenne

Hi, I have a table with 3 columns. I would like to delete the first 3
numbers in each record in the 'Account Number' column .i.e 000123456Y to
123456Y. Can anyone give me the criteria expression/code to do this. Thanks.
-Cheyenne
 
S

Sergey Poberezovskiy

I suppose the column you need to update is a Text, then
Update tableName
Set columnName = Mid(columnName, 4)

HTH
 
Top