It's always nicer to be in massive majority when you're wrong!

• This reply was modified 2 years ago by  kaspencer.

I fell on that point too!

I failed to note that two answers were required! When I have made that mistake previously, I have been given a second chance with a reply similar to: "Choose all...

The password for getting into the UK is SQLServerCentral!

My kids (they are both 40-something now) have to buy their own!

Best wishes,

Ken.

Steve, you're not the chap I thought you were.

Where's the Fuller's Golden Honeydew, and then where was the Guiness. (Or, have you drunk them all?).

Kenneth Spencer

Just a quick hint with the troublesome word "retriever":

'  "I" before "E", except after "C".  '

'morning Steve.

I thought the word was "Isolation", not "Isolated". Lockdown sentiments are showing through eh?

Ken

I really really must learn to concentrate more.

I have done this several times in past questions, now again on this one - clicked on an anwser without properly thinking and...

• This reply was modified 4 years, 6 months ago by  kaspencer.
• This reply was modified 4 years, 6 months ago by  kaspencer.

Am I allowed to point out that the use of the "Dense" results is in contradiction to the generally preferred, and advised, approach, where a gap equal to one less...

Exactly, George, as per my "one word example".

How about:

name.title();

Wouldn't that work for this one-word example?

• This reply was modified 4 years, 9 months ago by  kaspencer.

Thanks Steve ... as you can see, I guessed in the end, and guessed correctly. I would accept that the correct answer is the more probable meaning intended.

Best wsihes,

Kenneth Spencer

Re. the Omit question:

I find the expression "extract out" a bit confusing. Does it mean:

I wish to extract only the rows with NA ... ? (That is to include them...

• This reply was modified 4 years, 11 months ago by  kaspencer.

Nothing to do with the question, nor the fact that it is Christmas:

Does anyone else find that the "Stay signed in" option has ceased to function over the past fortnight...

I gave the correct answer but was marked as bening incorrect. Can I have my point and a cup of virtual coffee?

KA Spencer