I have a simple query that does this (see attached for output of query)...
WHERE JobdJobKey = 'PNOE143303' AND JobdStationIDKey='SMT2'
AND JobDInstruction IS NOT NULL
AND JobDInstruction <> ''
and what i need is to remove the data that is over to the right of the column and just keep all the data on the left of that column.
Hope that makes sense.