Including moderation.

To heck with Russell's Paradox.

Happy Easter to you and your family, Steve.

Best I can do while the coffee is perking, Emperor Palpitate.

It was ton a typo, Steve.

In books online (under "LIKE Comparisons") I found no syntax to support an OR. Nothing under the index topics of PATINDEX or WILDCARD, either.

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/581fb289-29f9-412b-869c-18d33a9e93d5.htm

Sometimes I read comments on these forums, and others, where people are recommending very elegant solutions to problems, however, they don't always take in to account the amount of time...

Kramaswamy,

I sincerely hope that you didn't take any of my comments as belittling your competence. Nothing of the sort was intended. My last...

In short, table variables are handled VERY much like temp tables. A couple of major differences follow:

Table variables aren't subject to logging.

Statistics aren't kept on table variables, which...

WayneS (4/1/2010)

---

I've got a theory about Paul... I think he has cloned himself. He then sends his clone out to "go forth and find all good sql nuggets", and then...

You've been going without sleep... haven't you?

I thought "hamster" was a collation.

Dangit... I hoped to be one-up on Gail just once before I die. Of course if F and E were reversed, there would have been no right answer.......

E

Paul, I'm curious. I understand right-padding the high value with char(255) to simulate a wildcard, but why add CHAR(1) to the low value?

Actually, I like this approach. The only thing I would suggest is to tweak it to accept character strings with a length greater than 1.

...