I need to un-concatenate for a query in Access. I need to separate a first name, last name and badge number. I don't need "Driver" in this anywhere. Just the name and badge number. Here are some examples of my information:
Driver: WALKER III, IRVIN W. (422103)
Driver: CASTRO COREA, JACKSON...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.