> > > > I thought about this (the design of my database) and couldn't see any > advantage of allowing nulls in those flds in the first place. If you have to have nulls you can experiment with COALESCE() although I didn't have much luck with it.