Combine Multiple Update Queries

[gall3on]

I was wondering if there was a way to combine multiple Update queries that affect a singular field. I have to rename several values in 'X' field so I can group it properly.

EG:
'Field X'
A1
A2
A3
B2
B3
B4

Expected update Result table:
'Field X'
A
A
A
B
B
B

 

[randy700]

Like =Left(A1,1) ?


Randy

 

[WinblowsME]

UPDATE Table1 SET Table1.data = Left(Table1.data,1);