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
STATUS = CASE
WHEN STATUS = ''
When Status in null i want to return 'F' and 'V'. Right now its returning Only 'F'. Can someone please help me solve this?