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