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

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