Category "isnull"

SQL Server - NULL vs blank in IF condition - ISNULL vs COALESCE

I am expecting ELSE part to be printed in this case. But it doesn't. It works if the input is blank ''. But for null, it fails. Even with ISNULL and COALESCE, i