Look a string within a range!

Hi,

I've a table with values Low & High.
ex: NRA* - NZ99

If the input is NR20, the script should tell me which range it belongs to.
I was thinking of splitting the word into alphabets & then comapring each alphabet which is not a modest way.
I was wondering if there are any other ways to do this.

Thanks