Trim

  • Thread starter Thread starter CVegas
  • Start date Start date
C

CVegas

Please advise syntax to trim all but the first 3 letters that are in a
field.

Field Name:[City]
Field Value: BOS Boston, MA
I want to retain the value BOS and delete Boston, MA

TIA
 
Please advise syntax to trim all but the first 3 letters that are in a
field.

Field Name:[City]
Field Value: BOS Boston, MA
I want to retain the value BOS and delete Boston, MA

TIA
Click to expand...
=Left([City],3)
 
You could type a query like this in SQL window : -

Update [YourTableName] Set [City] = Left([City],3)

Save query and execute and it should do for all records.

Regards,

Naresh Nichani
Microsoft Access MVP
 
Back
Top