in clause should display null if value is not there in sql server code example
Example: find value if not null in sql
SELECT FIRST_NAME , MANAGER_ID
FROM EMPLOYEES
WHERE MANAGER_ID IS NOT NULL ;
SELECT FIRST_NAME , MANAGER_ID
FROM EMPLOYEES
WHERE MANAGER_ID IS NOT NULL ;