Need help with an update statement

[cal555]

Hi,
I have writen this proceedure to update a field to N where it is Null. If the field has an N in it I would want it to leve it an dgo to the next record and so on. Hw en I run the procedure below it first sets this field to NULL for all the records and if I run it again it sets it to N. What am I doing worng that it just does not look at the field puts an N in it only if it is Null?


CREATE PROCEDURE [Set_Prom]
AS

UPDATE Da_Resp
SET [ProcStat] =
CASE [ProcStat]
WHEN NULL THEN 'N'
End
FROM Da_Resp

Any ideas would really be appreciated.
Thank You

 

[SQLDenis]

an update is a set statement no need to have update from with the same table

where is your WHERE clause?

UPDATE Da_Resp
SET ProcStat ='N'
WHERE ProcStat IS NULL


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[cal555]

Thanks that worked great.