Pull first 3 characters out of the data field

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

My USERID field have data like "EDD - VBTCP,RF1".
How can I use query to show in another field that pull
only the first 3 charaters "EDD" and igore the rest?
Please help!
Thanks
 
Back
Top