I have a procedure that will be passed in a value that will need to do an update to a field that is PIPE delimited
Here is the value to be updated
TRACK - RED BANK|TRACK - NEW STATION
If the value being sent in matches the left portion of the PIPE then I need to Delete each record in the table
If the value being sent in matches the right side of the PIPE then I need to Update all records to the right of the PIPE with NONE
> column Updated to 'TRACK - RED BANK|NONE'