I have a condition where utilizing the conditional operator, I need to use many arguments in the where clause. I've written the following query, however, I'm unable to utilize it in this context. Please advise me on how to utilize the case clause to return multiple parameters.
select * from cardimport
where
STATUS = CASE
WHEN STATUS = ''
THEN 'F'
ELSE STATUS
END
When Status in null i want to return 'F' and 'V'. Right now its returning Only 'F'. Can someone please help me solve this?