Removing Last Character from a Field using Query

[bconner]

I would like to remove the last character from a string in a field using a query. For example in the raw data below I want to omitt the 'A'

Raw Data:
MLKMIW17508A
LGMCM10007869705A
FA08-4405A

Results wanted:
MLKMIW17508
LGMCM10007869705
FA08-4405

 

[rainman89]

you can do this is your query

left ([yourfieldname], len([yourfieldname])-1) will return MLKMIW17508

 

[bconner]

Thank you very much!!!