Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: BETWEEN with LIKE
10-09-2008, 08:49 PM #1
- Join Date
- Oct 2008
- Thanked 0 Times in 0 Posts
BETWEEN with LIKE
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