www.3112.net > sql 模糊查询likE 如何处理 NULL %%在线等待

sql 模糊查询likE 如何处理 NULL %%在线等待

select SaleOrderNO,Man,ManDate FROM StorageMT where (SaleOrderNO like '@SaleOrderNO%' OR SaleOrderNO IS NULL ) AND (Man like '@Man %' OR Man IS NULL) AND (ManDate like '@ManDate%' OR ManDate IS NULL) ORDER BY SaleOrderNO DESC

一个模糊查询的列子,供应商编码 字段用的模糊查询 select * from spckd where 入库日期 between #2008-08-26# and #2008-09-26# and 供应商编码 like'%3%'order by 入库单号 至于如何用颜色标记出来,直接用sql的我还没接触过.一般通过应用程...

网站地图

All rights reserved Powered by www.3112.net

copyright ©right 2010-2021。
www.3112.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com