asp的SQL语句中and和or同时使用的注意事项（sql语句中as的用法和作用）深度揭秘


select case lcase(keyarr(I))
case “js”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%javascript%’)”
case “javascript”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%js%’)”
case “c#”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%csharp%’)”
case “csharp”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%c#%’)”
case else
sqlk=sqlk&” and title like ‘%”&keyarr(I)&”%'”
end select