Search BOL for the LIKE operator, click on the "Pattern matching in search conditions" topic.

declare @Rows table (Word varchar(25))

INSERT INTO @rOWS values ('color')

INSERT INTO @rOWS values ('colour')

INSERT INTO @rOWS values...

Steve Jones - Editor (2/14/2008)

---

Meaning we want something finished by Tuesday because we do. If that's the case, it will get done or it won't, but I'm not likely working...

I believe you're correct. So they take the lazy way out (which, since they're in charge, they can do). But the corollary is that HR and most managers don't...

Uh, you mean...

I'm in a small dev shop in a small affiliate of a regional healthcare provider. We are getting new database servers, and the central IT folks want us to...

I'm coming late to this thread, but I recently had a phone call from the alumni association of the public university in a small town in Illinois where I graduated....

It depends on the culture of the organization. Some places I've worked, I've been the only SQL Server guy, so I'm the guy in the office at 8 PM...

Another form of "insurance" that shouldn't be overlooked is a formal contract of some kind that spells out exactly what you will be doing for the customer. That avoids...

Don't ignore the insurance aspects, either. You're not covered under the employers workers comp policy anymore, so if you fall down their stairs, they aren't obligated to pay your...

Makes sense. Thanks, everyone.

Why do you say this, Ed? Is...

You're trying to exec @Query, but you're never adding the current @Filename to it.

WHILE @Count1 <= @FileID

BEGIN

SET @Count1 = @Count1+1

SET @Filename = (SELECT FileName FROM #Files...

OK, there was this guy I know, not me, who was unable to get replication working between servers so he came up with some stored procedures that would write to...

Just curious Steve, but just how did you "work that much harder for promotions"? Did you propose a quid pro quo? Or hope your effort got noticed?

Steve Jones - Editor (12/27/2007)

---

So many wonderful apps would die off if people were afraid to post, including this site. I enjoy the interaction with so many of you, even...