case when field is blank write something else display value

meadow_ryan

Have a field settlementID, I'm wanting to display when there isn't a value for that row to show pending else show the settlement id

 

something like when settlementID is blank then 'Pending' else settlementID

 

 

thank you

guitarhero23

How about something like

 

(CASE
WHEN `settlementID` IS NULL THEN IFNULL(`settlementID`,'pending')

ELSE `settlementID`
END
)

 

 

meadow_ryan

thank you