这样的sql 语句如何写??

[calfly]

某学校管理系统中
实现新闻针对部门发布

如，表news结构
-----------------------------------
id title content object
-----------------------------------
1 hello <long text> 1,2,3
2 note <long text> 3,4,5,6
3 good <long text> 4


object表示允许察看的部门代码
现有一属于部门2(userDpt=2)的用户，要从news表中选出所有允许部门2用户察看的新闻列表，
怎么写？？？

select * from news where userDpt 属于 object?????

[Ipkiss]

是用"like"关键字！

[new_life]

select * from news where object like '%,2,%' or object like '%,2' or object like '2,%'

[cmsoft]

select * from news where userDpt in object

[cmsoft]

不对，
select * from news where charindex(object,userDpt)>0

[zjp899]

Select * From News Where object Like '%,2,%'
即可！

[jsljy]

Select * From News Where object Like '2'

[buaawjh]

Select * From News Where object Like '%,2,%'

[DavidBone]

ding

[饮水需思源]

Select * From News Where object Like '% 2 %'

[xd123]

select * from news where object like '%," & userDpt & ",%' or object like '%," & userDpt & "' or object like '" & userDpt & ",%'