I need to pull out fields that have x and y (say 33-39) but what I am searching for is with-in a string of undefined length so I just cant use substring.
It there a way to do something like...
SELECT * FROM LookupTable
WHERE Priority between '%033%' and '%039%'
I know this does not work but I need sometihng with this logic