How to replace a value with null?

[BWIN]

Hi everyone,

I don't know why I am having so much trouble figuring this out as I feel it should be pretty simple. I have a table where, for one of my variables, refused to answer is coded as 777. I would like to make all values of 777 null. Any ideas?



Thanks

[June7]

Have you tried Find/Replace? Or an UPDATE action SQL?

[JoeM]

One easy way is to open up the Table, go to Replace (on the Find ribbon), and replace 777 with nothing, and it will remove them all.