求一条SQL查询语句

[PastMaster]

问题描述：
表tb_table1 (useridList 列 指 员工工号，类型为ntext)
id title content useridList
1 aa asf 011,012,013,
2 bb asdd 011,013,015,016,

我想搜出包含011员工的所有信息。
select * from tb_table1 where ','+useridList like '%,011,%'
这样写 提示说“数据类型 varchar 和 text 在 add 运算符中不兼容。”
谁能给个好的解决方法。谢谢

[让你望见影子的墙]

select * from tb where charindex(','+cast(useridList as varchar(8000))+',',',011,')>0

[等不到来世]

alter table tb_table1 alter column useridlist varchar(8000)

[htl258_Tony]

[Quote=引用楼主 PastMaster 的帖子:]
问题描述：
表tb_table1 (useridList 列 指 员工工号，类型为ntext)
id title content useridList
1 aa asf 011,012,013,
2 bb asdd 011,013,015,016,

我想搜出包含011员工的所有信息。
select * from tb_table1 where ','+useridList like '%,011,%'
这样写 提示说“数据类型 varchar 和 text 在 add 运算符中不兼容。”
谁能给个好的解决方法。谢谢
[/Quote]
try

select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%' 

[幸运的意外]

如果能确定useridlist字段的内容不会超过8000字符，那么可以先将useridlist转化为varchar类型后再检索。
select * from tb_table1 where ','+cast(useridList as varchar(8000))+',' like '%,011,%'

[v_oneforever]

[Quote=引用 8 楼 acupofnescafe 的回复:]
如果能确定useridlist字段的内容不会超过8000字符，那么可以先将useridlist转化为varchar类型后再检索。
select * from tb_table1 where ','+cast(useridList as varchar(8000))+',' like '%,011,%'
[/Quote]
that's right

[builderwfy]

select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%'

[usher_gml]

select * from tb where ','+cast(useridList as varchar(8000)) like '%,011%'

[ai_li7758521]

select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%' 

[alex_delki]

select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%011%'

[rex100]

帮顶

[liangCK]

CAST(useridList AS VARCHAR(8000))

[百年树人]

select * from tb_table1 where ','+(cast(useridList as varchar(8000)) like '%,011,%' 

如果这个字段的值不是非常巨大，可以试试上面这个转换

[百年树人]

[Quote=引用 2 楼 josy 的回复:]
SQL codeselect * from tb_table1 where ','+(cast(useridList as varchar(8000)) like '%,011,%'

如果这个字段的值不是非常巨大，可以试试上面这个转换
[/Quote]
写多了一个'('

select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%'

[sdhdy]

select * from tb_table1 where ','+cast(useridList as varchar(8000))+',' like '%,011,%'