I’m trying to create a query that will search for only the last three digits of a six-digit number i.e. ###123. I could use the ‘matches pattern’ for a single search HOWEVER, the last three digits fall over a range of numbers i.e. ###401 - ###950. I basically need to combine a like/matches pattern with a between statement. . A possibility would be to pass the numbers into a string variable and then parse it. Unfortunately I am not very well versed in SQL so any help would be greatly appreciated.
skaare (BOB member since 2004-07-01)