Case expressions may produce different results for null values if you enable set ansinull and include a when NULL clause in certain queries.
select CVT = case case_expression when NULL then 'YES' else 'NO' end from A
select CVT = case advance when NULL then 'YES' else 'NO' end, advance from titles
--- ------------------------ NO 5,000.00 NO 15,000.00 YES NULL NO 7,000.00 NO 8,000.00 YES NULL NO 7,000.00
set ansinull on select CVT = case advance when NULL then 'YES' else 'NO' end, advance from titles
CVT advance --- ------------------------ NO 5,000.00 NO 15,000.00 NO NULL NO 7,000.00 NO 8,000.00 NO NULL NO 7,000.00
See the Reference Manual: Commands.