CODEWITHSUNDEEP
sqlsql-servernullcase
Rich
Rich

Reputation: 49

CASE still returns null

Trying to get the output in Dx_3 to print '' if it is NULL but everything I have tried (NULLIF(), COALESCE(), ELSE '', etc) still prints a NULL. 

SELECT
    @RecordType AS RecordType_1
    ,AbstractData.AccountNumber AS AcctNum_2
    ,(SELECT
            CASE 
                    WHEN AD.Diagnosis IS NOT NULL THEN AD.Diagnosis
                    ELSE ''
            END
            FROM AbsDrgDiagnoses AD 
            WHERE (AD.DiagnosisSeqID ='1' AND AD.VisitID = AbstractData.VisitID)) AS Dx_3
FROM AbstractData --214
WHERE AbstractData.PtStatus <> 'REF'

Upvotes: 0

Views: 50

Answers (1)

Jeremy Cook
Jeremy Cook

Reputation: 22063

SELECT @RecordType AS RecordType_1,
       AbstractData.AccountNumber AS AcctNum_2,
       COALESCE(AD.Diagnosis, '') AS Dx_3
FROM AbstractData
LEFT JOIN AbsDrgDiagnoses AD ON AD.VisitID = AbstractData.VisitID
WHERE AbstractData.PtStatus <> 'REF' AND AD.DiagnosisSeqID = '1'

Upvotes: 1

Related Questions