类似这样的一条查询
SELECT * FROM OneTable WHERE CHARINDEX(N'一', Field)>0
AND CHARINDEX(N'元', Field)>0
AND CHARINDEX(N'天', Field)>0
你这么写 必须得三个字全有的能查出来
SELECT * FROM OneTable
WHERE CHARINDEX(N'一', Field)>0
OR CHARINDEX(N'元', Field)>0
OR CHARINDEX(N'天', Field)>0