Link to home
Start Free TrialLog in
Avatar of Sonia Bowditch
Sonia BowditchFlag for Guernsey

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
SOLUTION
Avatar of Rajkumar Gs
Rajkumar Gs
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sonia Bowditch

ASKER

Thank you both for your quick response.