1,217
社区成员




....
WHERE cast(replace(bianhao,'2010-1-','') as int) BETWEEN 5000 AND 6000
select * from tableName where left(BianHao,7)='2010-1-' and len(BianHao)=11 and
convert(int,right(BianHao,4)>=5000 and
convert(int,right(BianHao,4)<=6000
select * from tableName where left(BianHao,7)='2010-1-' and
convert(int,right(BianHao,4)>=5000 and
convert(int,right(BianHao,4)<=6000