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'
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.