On Fri, Sep 10, 2010 at 10:25:55AM -0700, Richard Broersma wrote: > On Fri, Sep 10, 2010 at 9:56 AM, Gauthier, Dave <dave.gauthier@intel.com> wrote: > > Ya, I kinda knew about these approaches. The problem ahs to do > > with novice users who don't know about coalesce or or;ing a check > > ofr nulls. I was hoping there was some special regexp expression > > that would match to a null. > > Perhaps the easiest was to help such users is to make the column(s) > in question NOT NULL DEFAULT ''.
I think it's a very, very bad idea to make a default like that. I'm aware that it's common in one of those Oracle properties, but it needs to stay confined there.