Query Update to remove last 3 characters of a string

[meagain]

I'm looking for a formula to use in an update query which will remove the last 3 characters in a string of variable length.

Thank you!!

 

[JerryKlmns]

Take a look at Left() and Len() build-in functions

 

[KenReay]

Update mytable set mystring = left(mystring,len(mysstring)-3);

using your tablename and column name of course

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[JerryKlmns]

Although I hate when I steel the joy from discovering new frontiers,

UPDATE yourTableName 
SET yourFieldName = Left([yourFieldName], Len([yourFieldName])-3)
WHERE Len([yourFieldName])> 3;

In case there are only 2 characters in the string of variable length.