LeftTrim and RightTrim

G

GGill

I nee d remove 2 first characters in the field. What function should i use in
a query?
For example: '1 group', I will need to have just a word 'group'.
 
D

Douglas J. Steele

If it's always the first 2 characters you're trying to remove, use
Mid(MyTextField, 3)
 
Top