Finding an empty field

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(at)ucsd(dot)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 *
**************************************************************************