I'm looking for a MS access SQL function similar to SUBSTRING but not quite as the length
of the data varies.
I have several values in a field we'll call field1
The value length varies from 2 to 5.
In all cases I would want to select the values except the very last character.
So for example:
computer browser mouse game zip
compute browse mous gam zi
Is there such a function?