How to check Null value in IF Condition in SQL Server 2005

Question

Dear Frnds I want to check a particular variable in which i m getting a value null by using If Condition. Please ellaborate by an example. Thanks Aamir

Jignesh Trivedi · Answer

hi try following code.. declare @checknull varchar if(@checknull is null) begin print('isnull') end else begin print('not null') end

Prabhu Raja · Answer

Hi Yes vulpes is Correct you can use ( IS NULL or IS NOT NULL) for checking a variable or parameter is null or not. example: if @Sequence IS NULL { @Sequence=0 }

Vulpes · Answer

Check out the IS NULL and IS NOT NULL functions: http://msdn.microsoft.com/en-us/library/ms188795.aspx The ISNULL function (no space between the words) is also useful for replacing a NULL value with something else: http://msdn.microsoft.com/en-us/library/ms184325.aspx