22,209
社区成员
发帖
与我相关
我的任务
分享
select * from(select case when isdate(sj)>0 then sj else '19000101' end as sj1,* from #tb where ISDATE(sj)>0)tmp
where CONVERT(int,sj1)>20130301
select tmp.* From (select * From table_A Where PATINDEX('[0-9]%[0-9]',sj)=1 and isnumeric(sj)=1 )as tmp )
Where Convert(int,tmp.sj) > 20130101