Re: SQL query for NULL field entries

In article <8990@emory.mathcs.emory.edu> caulds%deh1@redstone-emh2.army.mil (Charles Aulds /AMSMI-RA-EH-RM/876-0889) writes: >X-Informix-List-ID: <list.1213> > >What I want to do is select records where a specific field contains >no entry. The following line does NOT work, but will illustrate what >I need to do: > > select jocpbc.* from jocpbc where pbcj=" "; The keywords IS NULL or IS NOT NULL are whatfor you are seeking. Try.... select jocpbc.* from jocpbc where pbcj IS NULL Don "merely scratching the surface of the SQL NULL experience" Bolton