Re: sql select

You might try checking for "null string", i.e. "", which IS NOT NULL. cheers, jw James Dickin wrote: > I am trying to select records that have null values in a specific field > using: > > SELECT * FROM table_name WHERE field_name IS NULL> > the field_name is a single character field. > This returns ' No rows found' (I know there are records with null values) > I also tried the above leaving out the WHERE statement and it only returned > the records that had a character in the field_name and not those without. > There are other records with null value fields in the same table and it > selects these OK > > What can cause this behavior?