NULL comparison

Question

Hello all,

There is a query:

UPDATE MyTable SET nvarchar1 = 'blahblah'
WHERE Id = '096fe792-7313-416f-b3c8-327f46be73b6' AND nvarchar1 <> 'blablah'

It doesn't work, when nvarchar1 is NULL. How should I change it to make it work?

1. It is important to me don't execute update, if value has not been really changed.
2. I don't know column type. It can be not only nvarchar, but ntext, integer or float-point number as well.

Regards,

Answer 1

UPDATE MyTable SET nvarchar1 = 'blahblah'
WHERE Id = '096fe792-7313-416f-b3c8-327f46be73b6' 
AND (nvarchar1 IS NULL 
OR nvarchar1 <> 'blablah')

Do you mean this?

Answer 2

UPDATE MyTable SET nvarchar1 = 'blahblah'
WHERE Id = '096fe792-7313-416f-b3c8-327f46be73b6' AND isnull(nvarchar1,'') <> 'blablah'