SQL Server——在varchar字段中选择两个数字范围内的文本和数字

I have a table with ranges of numbers from 0-2000000. I can use a between statement to get the records of things if I do a BETWEEN 50 AND 100. That works. I have a table with ranges of numbers from 0-20