john.arnott (7/12/2010)The QOD not only calls our attention to this specific behavior in the REPLACE() function, but also to the general issue of understanding and programing to handle NULL.
I see your point. unknown in = unknown out.
Harsh reality in some cases.