字符怎么拼接

[验证码识别]

select * from character as tab1 where '|4|5|' like ‘|' + raceid '|'

帮看看, 哪里错了, 主要是‘|' + raceid '|' 要怎么拼接


raceid 是字段名，里面的值
----
4
5
6
-----

上面需要怎么改？ 主要是字符怎么拼接

[cd731107]

select * from a as tab1 
where '|4|5|' like '%|' + ltrim(raceid)+'|%'

[AcHerat]

select *
from a
where '|'+ltrim(raceid)+'|' like '|4|5|'

[AcHerat]

select *
from a
where charindex('|'+ltrim(raceid)+'|','|4|5|')>0