Maybe I stumbled across the answer without realizing it or I'm not using the right terminology to search for the answer I need.
SELECT a.a IF a.b = 'X' else NULL
I've tried it:
SELECT (IF a.b = 'X' SELECT a.a) AS Note
WHERE a.b = 'X' or is NULL <Both with and without the 'or is NULL'>
Thank you in advance for your time.