just wonding the best way to do a ranged search.
say the user enters:
"R01% - R02%" or
"R01 - R0332441" or
"1 - 99999" (this one is very easy) or
"A1??DDS - FR6%" ( i think this one would too difficult) ,

what would be the best way to get the desired results?

any help would be appreciated
- jer