22,206
社区成员
发帖
与我相关
我的任务
分享
with orderdetail(producttype) as
(select 1001 union all
select 1000 union all
select 1001.1002 union all
select 1003.1001)
select * from orderdetail where charindex('.1001.','.'+cast(producttype as varchar(50))+'.')>0