执行脚本,没有结果
;with T as(
select '09 22 25' notext
union all select '16 18 29'
union all select '11 21 23'
union all select '06 08 19'
union all select '03 05 25'
)
,T2 as(
select '25' SEQ
union all select '29'
union all select '19'
)
select notext from T where notext LIKE '% + select CAST(SEQ AS INT) from T2 + %'
想得到的结果
notext
09 22 25
16 18 29
06 08 19
03 05 25