update and null value

[softboy12]

Hi all

i have a problem with the following query
-----------------------------------------------------------
UPDATE [data].[dbo].[Kunden] SET [OS]='NT' WHERE [OS] =NULL
-----------------------------------------------------------
The SQL Server says me "no rows affected"

how can i fill in datas in a row, which i created before and which is now set to NULL, i tried also with insert into but this doesn't work

many thanks in advance

best regards

E.Altherr

 

[r937]

WHERE [OS] IS NULL

you cannot use ordinary operators like =, <>, etc.


rudy

http://r937.com/

SQL Consulting

 

[softboy12]

thanks this works fine

best regards

E.Altherr