Question

ASP MSSQL 查询一个字段里包含几个中文或者为空的语句

sql="select * from zjg where users_id="&session(""&user_id&"")&" and sto_money is null and (order_province not like '%江苏%') and (order_province not like '%上海%') or order_province is null

我要查询order_province地段里不包含"江苏",或者不包含"上海",,或者为空,,,,
如何修改,高手指教,非常感谢.

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励10（财富值+成长值）+提问者悬赏20（财富值+成长值）

Answer 1

select * from zjg where users_id="&session(""&user_id&"")&" and sto_money is null and
(
(order_province not like '%江苏%') and (order_province not like '%上海%') or order_province is null
)