Re: Inserting surname of Null from a subquery results in a NULL value

jbainbridge_at_gmail.com wrote:

> Okay first up this is not a NULL vs. Empty String thing as I am well
> aware of that little gotcha but instead it is when a 'Null' string (a
> person's surname is actually Null) is returned by a subquery to be used
> in an insert or update statement it is actually inserting a NULL value
> instead of the text Null.
>
> Does anyone know a way around this amusing problem?
>
> Cheers,
> --
> Jason Bainbridge
> KDE - Conquer Your Desktop - http://kde.org
> KDE Web Team - webmaster_at_kde

No problem with any of my databases ... look for something else ... a constraint, trigger, etc.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)