SQL Server CE 用Select Case 來將欄位NULL值轉為0
?
SELECT (CASE WHEN PUR_AMT IS NULL THEN 0 ELSE PUR_AMT END) PUR_AMT FROM PDA_PCOTI
