关于SQL问题，请各位高手指点一下！

[as2001]

请问如果我要用SQL语句查看字段里有没有包含某些字符，应怎么实现？

[511214]

set conn=server.createobject("adodb.connection")
conn.open "driver={sql server};server=server名;database=databasename;uid=sa;pwd=passward;"
sql="select * from article where title like '%" & 要包含的字符& "%'"
set rs=conn.execute(sql)
if rs.eof and rs.bof then
"包含"
else
"不包含"
end if

[lions911]

sql="select * from article where title like '%" & 要包含的字符& "%'"

[lindexter]

同意

[vivisogood]

% 可以吗？

[diya]

sql="select * from 数据表 where 字段名 like '%字段值%' order by 字段名 [desc]"