How to search a field containing multiple values separated by a bar |
Posted on 2011-02-14
I have a table that contains a field with multiple values separated by a bar |.
I need to select on the 2nd value.
I have tried using the LIKE command with %|value|% = 10
This picks up any value that matches 10, no matter what position te 10 is in.
I tried using the LIKE command with %|value_|% = 10
This still picks up any match with a 10.
Is there a way to create a select command that would only pick up a match on the 2nd value?