Finding an empty field - Mailing list pgsql-general

I'm having trouble finding empty fields so that I can fill them.

This type of query seems to yield no returned rows:

   SELECT * FROM TABLE WHERE FIELD1 IS '';
or
   UPDATE TABLE SET FIELD1 = 'SOMETHING' WHERE FIELD1 IS '';


I've also fooled around with EMPTY and NOT EXISTS, but I can't get it
right.

What do you recommend to find empty fields?

Thanks,
Gary

**************************************************************************
* Gary B. Hoffman, Computing Services Manager  e-mail: ghoffman@ucsd.edu *
* Graduate School of International Relations and Pacific Studies (IR/PS) *
* University of California, San Diego (UCSD)       voice: (619) 534-1989 *
* 9500 Gilman Dr., La Jolla, CA 92093-0519 USA       fax: (619) 534-3939 *
**************************************************************************