Query Problem. Parsing?

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)

Can you create a new object in Designer to substring the last 3 digits?


scott copeland (BOB member since 2002-08-15)

Unfortunately no. I have to attack it from the report side.


skaare (BOB member since 2004-07-01)

Create a complex filter in the report, using the Reporter functions:
Between, SubStr, ToNumber


Andreas :de: (BOB member since 2002-06-20)