[V4WS] UPDATE...WHERE problem

[Solon Morse]

> Correct is
> 
>     WHERE fld is NULL
>              ^^^   

But I'm tyring to SET f to null, I'm not searching for null field, as in

UPDATE tbl SET f = NULL WHERE f = 'whatever'

"f IS NULL" produces an error (Expected '=') in this case.

Thanks,

Solon
-- 
Solon Morse
Assistant Director of Education
Roger Tory Peterson Institute
311 Curtis Street
Jamestown, NY 14701
Jamestown: (716) 665-2473 ext 243
Buffalo: (716) 886-1920
smorse at rtpi.org