I cannot tell a lie... I ran the code before answering this one. 😛

I wanted to pick '1234567890' but I wanted to prove I was "right" first. What a surprise! I, too, will be using COALESCE more often...

Who knew that a NULL would have a character length of 1??? (in this case) Can't wait to stump my friends with this one!