Thank you Ray. Are there any tutorials out there that might help me understand this process?
I managed to get an update query to update one of the columns but haven’t worked out how to strip data from a column.
I’d looked at string functions - left, right, instr and trim. Is that what we’d be running?
Any advice greatly appreciated. Trying to save us some time in the premier support session.