I'm assuming you just gave us names of customers instead of their alphanumeric customer ID for simplicity's sake. Since you said you wanted to sort and...

EDITED TO REPORT TEST RESULTS

Use Lowell's dynamic SQL method above. It's simpler, faster, and will only increase its lead as the number of words in the

search string...

Many beers in fridge, we can make a campfire out back with the ISO standards.

By the way, does anyone else here follow the online comic XKCD?

It is...

I have never before attempted this feat without a net, but my wife is asleep, so I'll take a shot at it. You DO know this is going...

Great... you mention Joe Celko and now I've got the title song to Flash Gordon running through my head.

Does that mean all pork chops, katanas, longbows, and trebuchets would have to be checked at the door? Doesn't sound like much of a party to me......

Fine then. Me and Roy will just pack up our CTEs and go home.

I take the afternoon to focus on my day job and come back to find all this? My oh my.

Thanks to all y’all who supported “my” solution...

Nah.... I'd never get invited.

Seriously, what is to be gained by exclusivity? If you have a complex topic or problem you want to discuss, why not just ask...

Amen.

(This was in response to Lynn not being a Saint, and therefore not being dead.)

After considerable pondering, I've eventually come around to "If it ain't broke, don't fix it." I know I prefer this forum, and it's because there is so much...

I could accept that...

Sloppy typing on my part guys. "MSDN MVP" should read in full "MVP / MSDN Moderator". Please understand that I have great respect for the...

There's nothing wrong with comments. Their use is to be encouraged and applauded, yet rarely do I feel the need to...

One nice thing about searching syscomments is that it SOMETIMES catches a string being built in dynamic SQL.