Strip Characters? Left() ??
Posted on 2007-04-04
How can I strip characters in SQL?
I have this code in my where statement
WHERE some_id IN (4|y,5|y,6|y)
I want to remove the |y or |n, basically its "y" for yes and "n" for no, but I need to remove that if possible.. so I am left with:
WHERE some_id IN (4,5,6). It will always have that structure. In some cases the id might be 256|n, 257|y so its not just 1 digit to the left of the pipe delimiter
Any help appreciated.