Sonia Bowditch
asked on
T-SQL Query to include null values
Hello Experts,
I have a T-SQL query :
SELECT * FROM TableX
WHERE column IN (a, b, c, d, e, f)
I have been asked to include NULL values in this select. I could remove the WHERE clause and take the table and filter out everything other than the required a, b, c, d, e, f, NULL which I have tried but it leaves a mess.
Would someone have an idea how I could do this?
Thanks
InfoSec36
I have a T-SQL query :
SELECT * FROM TableX
WHERE column IN (a, b, c, d, e, f)
I have been asked to include NULL values in this select. I could remove the WHERE clause and take the table and filter out everything other than the required a, b, c, d, e, f, NULL which I have tried but it leaves a mess.
Would someone have an idea how I could do this?
Thanks
InfoSec36
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER