Mostly a trick if you have columns misnamed and are trying to address them by the name, as opposed to location. I think location code is always more brittle,...

seems a bit counter-intuitive to me.

i would have used champs[2], myself...

but all in all, a good reminder, thanks Steve

Nice, easy question, thanks Steve

Interesting, never followed Lacrosse (the major sports here are Rugby, Cricket and Soccer(football to the British) )

Didn't know this, so learned something new, thanks Steve

Nice question, thanks

Really need to dust off my R

Nice question, thanks, Steve

Interesting question, thanks Steve

I seldom have had the need to use this function, so learned something...

Nice, simple question to start the week on, thanks Steve

Nice reminder, thanks Steve

Nice one, thanks, Thom

there have been times when the use of COALESCE has come in pretty handy...

Nice question, thanks Steve

particularly enjoyed the red herrings

Good question, thanks Junior.

Nice new option... learned something today

At the time of this post, I see that 18% (a whopping 42 out of 230) of the...

Nice, easy one to start the week on, thanks Steve