SELECT * FROM DeliveryOrder AS D WHERE ISNULL(D.CarrierCode,'') != '' 判断为空也是 ISNULL 如果是ISNULL 返回后面的''