I need to know which fields have an empty string in them. So I tried it with one of the fields and it works. My manager thinks that with different data-types it would not, but I'm pretty confident that this will do the trick regardless of what data type the field is:
So whos correct?
Thanks.
Code:
SELECT CM.ControlID, CM.LoanNumber
FROM tblControlMaster CM
WHERE CASE WHEN NULLIF(CM.LoanNumber, '') IS NULL THEN 0 END = 0
ORDER BY CM.ControlId
So whos correct?
Thanks.