Robert,
> Is there anyway to do be able to change the '' into NULL before data> validity is checked with a trigger?
What about using a RULE instead?
-- Josh BerkusAglio Database SolutionsSan Francisco