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