wit_jp2001 (1/24/2014)
Chris - Thanks works great.
If your final code is still using an "=" sign for a NULL test, then it might not actually be doing what it's supposed to be doing. If you have "Concatenate NULL Yields NULL" turned off to make such bad code work, then you're going to be in a heap of trouble when MS no longer gives you the option to turn it off.
--Jeff Moden
Change is inevitable... Change for the better is not.