How to search alpha numeric range?

Databases
1

Hi,

I have a db in which i have 3 fields i.e:

RangePrefix, StartRange, EndRange

Example data in db:
“”, 0A, 9Z

Now if someone searches for 8A or 9A what will be the query to display that ?

Thanks.

2

SELECT RangePrefix FROM sometable WHERE StartRange <= ? AND EndRange >= ?