I have an account field that is a character. I want to allow the use to choose a range of accounts. Here is the dilemna

if I choose the range of accounts of 01-10 to 01-10 meaning I just want that account, all accounts that begin with 01-10 are retrieved.

01-10
01-101
01-102

even in the command window when I but the following statements in I get the same results.

select distinct ubnum from ubtrans where between(alltrim(ubnum),'01-10','01-10')
select distinct ubnum from ubtrans where alltrim(ubnum) >= '01-10' and alltrim(ubnum) <= '01-10'

How can I stop this from happening?