I try using the sql server 2000 to retrieve date using Between

the first data will counted but the last will not counted.

Example:

Name between 'A%' and 'C%'

just will get the A...