SQL stored procedure variable null checking
sql, stored-procedures
Solution
Use
IF @DefaultID IS NULL
Instead of `IF @DefaultID =''`
`NULL` and `''` are two different things.
Problem
Below is part of a stored procedure that I have, it would be of great help if you can point me why is that even when `@DefaultID` is null after executing the select statement it does not enter the if condition, is there are different method I have to follow to assign the value to `@DefaultID` for it to be available for null checking. Thank you in advance. ``` DECLARE @DefaultID varchar(25) DECLARE @ISDefault varchar(1) SELECT @DefaultID = (SELECT TABLE1.DEFID as DEFID FROM TABLE1 WHERE TABLE1.ID = '123') IF (@DefaultID = '') SET @ISDefault = '1' ELSE SET @ISDefault = '0' ```