select *from 表where cast(char列 as int) between 1000 and 2000----把该列转换类型转成数字类型再对比就行
先用函数转换成整型再比较:cast(char类型字段 as int) between 1000 and 2000
