sql语句很“刁”的进来 指导

[春风十里耶耶耶]

SELECT CanLogin='1' FROM Users where UserCode=
{000515,
009802,
004498,
008096,
008147}
解释：CanLogin='1'代表可以登录 UserCode是人员的工号。
想要的效果是：执行查询后，结果显示为可以登录的人员工号。在{000515,009802,004498,008096,008147}里面中可以登录的人员在显示结果中显示出来。

我写的地方哪里不对，指点一下，谢谢。

[jaydom]

SELECT UserCode FROM Users where UserCode in ('000515','009802','004498','008096','008147' and CanLogin='1' )

[百年树人]

SELECT * 
FROM [Users] 
where CanLogin='1'
and
UserCode in('000515','009802','004498','008096','008147')

[guguda2008]

=只能比较单个值。

[flysky_lzy]

SELECT UserCode
FROM [Users]
where CanLogin='1'
and
UserCode in('000515','009802','004498','008096','008147')

[水族杰纶]

where
charindex(','+UserCode+',',','+'000515,009802,004498,008096,008147'+',')>0

[水族杰纶]

--防止UserCode是数值型 转换下
where
charindex(','+ltrim(UserCode)+',',','+'000515,009802,004498,008096,008147'+',')>0

[andy_liucj]

[Quote=引用 1 楼 jaydom 的回复:]

SQL code

SELECT UserCode FROM Users where UserCode in ('000515','009802','004498','008096','008147' and CanLogin='1' )
[/Quote]兄弟，括号放错地方了

[andy_liucj]

SELECT UserCode FROM Users where UserCode in ('000515','009802','004498','008096','008147') and CanLogin='1' 

[春风十里耶耶耶]

[sql code]
select
[/sql]