No no, what I need is something like this

My query is ..

SELECT
'ACCOUNT NO' = act.ACCOUNT,
'Auto Recharge' = CASE WHEN act.AUTO_RECHARGE = 1
THEN
CASE acr.IS_RECHARGE_CARD WHEN 1 THEN 'PAYMENT DONE'
END
ELSE ''
END,
FROM ACCOUNTS act, CREDITCARD acr
WHERE
act.ACCOUNT = ACR.ACCOUNT


After executing it, I got following Resultset
A00001 'PAYMENT DONE'
A00001 NULL


[CREDITCARD Table has values like

ACCOUNT IS_RECHARGE_CARD
A00001 0
A00001 1

This is occuring when there exists 2 values as 0 & 1 for the field IS_RECHARGE_CARD and I don not want to disturb any clause after WHERE

From above I need to select only record with proper values , not records with NULL or BLANK