求一sql 匹配查询语言

[netbin]

有表 test

T(nvarchar) F
t1 121
t2 12
t3 1
t4 1,12,121

查询 F 包含12的记录，但不包括是 121,1212之类
select * from test where ???

[netbin]

添加上面想得到你的结果
t2 12
t4 1,12,121

[txlicenhe]

select * from test where charindex(',12,',','+F+',') > 0

[txlicenhe]

select * from test where charindex(',12,',','+F+',') > 0
或
select * from test where ','+F+',' like '%,12,%'

[pengdali]

select from test where ','+f+',' like ',12,'

[pengdali]

select * from test where ','+f+',' like '%,12,%'

[Wally_wu]

select * from test where (f like'12%') and f <>'121' and f <> '1212'

or

select * from (select * from test where f <> '121' and f <>'1212') where f like '12%'

[zjcxc]

select * from test where ','+F+',' like '%,12,%'

[netbin]

ths

[changechange]

select * from test where ','+F+',' like '%,12,%'

[lijinqiang]

select * from test where f like '12%'and f like '%12%'and (f not like '121%')and
(f not like '%1212%')

[CrazyFor]

select * from test where charindex(','+'12'+',' , ','+F+',') > 0
或
select * from test where ','+F+',' like '%,12,%'

[gmlxf]

select * from test where ','+F+',' like '%,12,%'