求一SQL语句！！！！

[miniburger]

有一个表
table1
字段：
Caccount varchar(20)
Ctelephone varchar(10)

现在要计算出电话号码在3814XXX----3825XXX区间内的用户数，这句SQL语句怎么写？

[victorycyz]

select caccount
from table1
where ctelephone between '3814' and '3826'

[victorycyz]

用户数，刚才看错了。

select count(*)
from table1
where ctelephone between '3814' and '3826'

[miniburger]

BETWEEN可以用于计算字符型数据的吗?

[friendliu]

select caccount
from table1
where substring(ctelephone,1,4) between '3814' and '3826'

[miniburger]

select count(*)
from table1
where ctelephone between '3814' and '3826'

与

select count(*)
from table1
where ctelephone like '3814%' or ctelephone like '3815%'........... or ctelephone like '3825%'

计算出来的结果不一样喔！为什么呢？？

[miniburger]

TO 无为：
加了SUBSTRING之后，运算速度就明显慢很多了。如果不用这些转换函数还有什么其它写法吗？

[miniburger]

再TO 无为：
而且你这句的运行结果与中海那句是一样的。
还是与这句，最原始的写法运算出来的结果不一样。到底哪个对？

select count(*)
from table1
where ctelephone like '3814%' or ctelephone like '3815%'........... or ctelephone like '3825%'

[ocean9b]

select count(*) from table where cast(ctelephone as int)>=3814000 and cast(ctelephone as int)<=3825999

[miniburger]

还有其它吗？？

[wshcdr]

STUDY

[attila2003]

select count(*)
from table1
where convert(int,substring(ctelephone,1,4)) >= '3814' and convert(int,substring(ctelephone,1,4)) <= '3826'