求助啊！ACCESS数据查询

有一个表
  id key
  1 a,b,c,d
  2 a,b,c
  3 a,c,d
  4 b,c
  5 c,d

如何查询包含 a 的 id 啊？
access + asp
 

VBScript code

sql = "select id from tb where key like '%a%'"
conn.execute sql

VBScript code

<%
sql = "SELECT id FROM tbl WHERE ',' + [key] + ',' LIKE '%,a,%'"
Set conn = CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\xxx.mdb;"
Set rs =  CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,1
Do While Not rs.EOF
    Response.Write rs(0)
    rs.MoveNext
Loop
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
%>

SQL code

select id from tb where [key] like '%a%'

楼上都把酱油买了
俺是来凑凑热闹

id key
  1 a,b,c,d
  2 a,b,c
  3 a,c,d
  4 b,c
  5 c,d
 

例如：a=张三
  b=李四
  c=王五
  d=赵六
查询结果是 id=1
如何显示 张三，李四，王五，赵六

SQL code

select id,[key],replace(replace(replace(replace([key],'a','张三'),'b','李四'),'c','王五'),'d','赵六') as xm  from tb