I just want to make a SELECT that returns 1 (one) if the field is NULL and 0 (zero) if the field is NOT NULL. The fields are varchar or datetime. I’ve tried something like that but it did’nt works:
SELECT BirthDate IS NULL, Name IS NULL FROM CUSTOMERS
Thanks in advance for any help.
