rewrite below incorrect statement in two ways using isnull and coalesce
select * from Test_Table where Test_ID=null
SELECT TOP 10 *
WHERE (NULL, Coalesce) IN SearchTerms
--if first column/Test_ID is null, use value from second column which is ''
WHERE COALESCE(Test_ID, '') = ''
--if Test_ID is null, return ''
WHERE ISNULL(Test_ID,'') = ''
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)