ASP+access里charindex的用法

[idhgd]

ID为aaa表的ID列，'1,2,3'为ID列里的编号的值，用逗号分隔。
我想通过以下语句查询编号分别为1,2,3的数据，不可以得到结果。请问，问题出在哪里，正确的该怎么写？
sql="select * from aaa where charindex('1,2,3',id)>0"

[idhgd]

sql="select * from aaa where instr('1,2,3',id)>0"
试了好像不行，不明原因。用split函数数组字符串后循环实现。

[idhgd]

sql="select * from aaa where instr('12,14,16',id)>0"
使用这个会把ID为2,4,6,1的数据也查询出来

[wwwwb]

select * from aaa where instr('12,14,16',',' & id & ',')>0
准确查找

[idhgd]

set rs=conn.execute("select * from aaa where instr('12,14,16',',' & id & ',')>0")
这样？

[idhgd]

这样只查出14来

[idhgd]

set rs=conn.execute("select * from aaa where instr(',' & '12,14,16' & ',',',' & id & ',')>0")

这样就可以了

[wwwwb]

select * from aaa where instr(','& '12,14,16' & ',',',' & id & ',')>0

[idhgd]

那12，14，16换成变量呢？a="12,14,16"

[wwwwb]

SELECT instr(',' & a &',',',3,')

[idhgd]

set rs=conn.execute("select * from aaa where instr(',' & '12,14,16' & ',',',' & id & ',')>0")

这一整句，里面的12,14,16换成变量a怎么写？

[idhgd]

set rs=conn.execute("select * from aaa where instr(',' & a & ',',',' & id & ',')>0")

这样写不行

[wwwwb]

set rs=conn.execute("select * from aaa where instr('," & a & ",'" & ",'," & ID & ",')>0")

[idhgd]

[Quote=引用 15 楼 wwwwb 的回复:]
set rs=conn.execute("select * from aaa where instr('," & a & ",'" & ",'," & ID & ",')>0")
[/Quote]
这个不行，查不出来

[wwwwb]

Set rs = CurrentDb.OpenRecordset("select * from a where instr('," & aA & ",'" & ",','&" & "ID" & "&',')>0")
Do While Not rs.EOF
MsgBox rs(0)
rs.MoveNext
Loop

[idhgd]

试了上面的不行。

<%
a="12,14,16"
set rs=conn.execute("select * from aaa where instr(',"&a&",',id)>0")
%>

这样出来的值是有id为1,2,4,6,12,14,16的值，如何改成只有12,14,16的值？

[ACMAIN_CHM]

<%
a="12,14,16"
set rs=conn.execute("select * from aaa where instr(',"&a&",',',"&id&",')>0")
%>

[idhgd]

[Quote=引用 19 楼 acmain_chm 的回复:]
<%
a="12,14,16"
set rs=conn.execute("select * from aaa where instr(',"&a&",',',"&id&",')>0")
%>
[/Quote]
这样是不行的，查询没有结果

[idhgd]

ID是自动编号的字段

[idhgd]

难道注定我要用循环……

[wwwwb]

17楼的代码 是测试通过的