UPDATE/SET

[pabby]

hi,

I have a table with a column called test. When I input data into this table the TEST column does not get populated - this is deliberate. I have been manually updating this column with an alphabetic letter so that I can then run a query "Select * from tblname where TEST = 'a'. This way I can pull certain records. Up till this point the TEST column is full of <NULL>'s

I have been trying to update the table by saying something like "UPDATE TBLWHATEVER SET TEST = 1 WHERE TEST = 'NULL'

THIS IS NOT WORKING ,

ANY IDEAS ?

THANKS,
PAUL

 

[SQLDenis]

WHERE TEST IS NULL


“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/