I have a few rows of data in a microsoft access table similar to the attached.
The fields Title and ItemNum are my current two fields. I need a query that will update the DesiredOutputField with the values as seen in the attached database.
The goal is to parse out any data from the beginning of the Title field that matches the itemnum field.
If nothing matches, then leave blank.