Yes! There was a really funny Question of the Day about names.

Always feel free to tweak away, Paul.

Don't define something in a RETURN that you don't actually want to return. You need to omit that column.

This means that you will...

Dave's right. Here's a good practice tip:

@@ROWCOUNT changes with each new SET or SELECT, so if you want to hold on to the...

The bit about COLLATEs is new to me. I'll have to test it out. Where did you pick up that bit of information?

I'm sure there must be a spatial solution too.

I finally throw up a solution you like, so you critique my set up of the sample data. There's no...

No recursive CTE this time, Paul? 😉

This will let you replace a set of words with whatever replacements you choose.

declare @tab table (findWord varchar(50) primary key, replaceWord varchar(50))

declare @result varchar(4000)

declare @string varchar(4000)

set @string = 'here...

Actually, I misunderstood the requirements. Sorry. I shouldn't try to work when I'm tired.

My solution reaches back to the last valid value for a...

A good question... but people ask ME why I live where temperatures routinely...

To be honest, there is no comparing winter down south to winter up north. Especially this year. We get at most a few weeks of temperatures...

I can't get that excited about a school whose cheerleaders all resemble Admiral Ackbar... with curls.

I remember the first time I ever had a gin and tonic. The invitation to go out for happy hour went something like this.

1. Spring is...

Grant, did you by any chance attend mighty Miskatonic University? Home of the Fightin' Shoggoths?

And what about those Midwestern States... Ohio... Iowa? Talk about consonant-challenged.