Thanks for this instructive question.

-- webrunner

Same here.

Your editorial is sad, but true. I guess somebody had to say it. I don't think this issue is unique to SQL Server, but the older I get, the more...

• This reply was modified 6 years, 5 months ago by webrunner.
• This reply was modified 6 years, 5 months ago by webrunner.

Thanks for this instructive question!

- webrunner

Thanks for this informative question.

- webrunner

Thanks for this impressively comprehensive list!

- webrunner

Thanks for this instructive question. 

- webrunner

Yes, thanks. Seems like that is what ISNULL() is for, as I mentioned. And explains why REPLACE() was made to return NULL if any parameter is NULL.

Thanks again.

Thanks for the instructive question. But why is it that the REPLACE() function returns NULL even if the search parameter is NULL? Why was that decision made? Just curious.

Thanks for the info! It gives me a sense of when and why these values would be blank.

Regarding this question from insharh2297 "Which brings up the issue: How...

OK, so I made some progress. 

Drew - the TRY_CAST returned NULL, so for whatever reason trying to cast the varchar(max) column directly into XML returns that error you...