Re: Excluding null values

Ms. Cowling,

> I have a table which stores a list of locations that a person can
> have. In my application I need to get this list of locations, but I
> don't want the list to contain any null values, a person must have
> at least 1 location (done in application code) but the rest of them
> can be null, only when I bring up the list of possible locations for
> a person I only want the not null ones, is there any way of
> achieving this in sql, or will I need to do this at the application
> level? Normally I would just say where column is not null, but
> there are 11 columns in this table that can be not null.

Hmmm ... I'm not sure where to start. Your database design is *not*
normalized. Is this a legacy structure you're saddled with, or is it
possible to re-design it?

-Josh