34,575
社区成员
发帖
与我相关
我的任务
分享
select * from table where substring(ccode,1,2) between '02' and '06'
declare @table table (ccode varchar(50))
insert into @table
select '01*******' union all
select '01*******' union all
select '01*******' union all
select '02*******' union all
select '02*******' union all
select '03*******' union all
select '04*******' union all
select '05*******' union all
select '06*******' union all
select '06*******' union all
select '07*******'
select * from @table
where left(ccode,2)>='02' and left(ccode,2)<='06'