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 *
**************************************************************************