How to find the Value is returned Null.

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

jpipes SSChampion Points: 12230 More actions · Answer 1

Why are you selecting the name, and then setting equal to null? Do you mean to check whether the value is null? If so, try:



declare @s varchar(10)

select @s=name from table

if @s IS NULL begin

--do operation

end

PBirch SSCrazy Eights Points: 8493 More actions · Answer 2

You should always use column IS NULL rather than column = NULL. Nulls do not equal each other (or itself).

Patrick

Quand on parle du loup, on en voit la queue

Antares686 SSC Guru Points: 125444 More actions · Answer 3