SELECT *;iif(isnull(wpd) or empty(wpd),9,wpd)
FROM sao001 Sao001;
WHERE Sao001.qty_bal < 0;
AND ALLTRIM(Sao001.products) = "4";
ORDER BY Sao001.o_order, Sao001.month, Sao001.period, Sao001.case_no,;
Sao001.po_no, Sao001.lot_no
SELECT *;
FROM sao001 Sao001;
WHERE Sao001.qty_bal < 0;
AND ALLTRIM(Sao001.products) = "4";
ORDER BY Sao001.o_order, Sao001.month, Sao001.period, Sao001.case_no,;
Sao001.po_no, Sao001.lot_no
這是原來視圖得sql語句,要求對其wpd欄位的值為空的記錄賦值為9,我不知用何种方法實現。