Sushila! Haven't run into any of your posts in quite a while! So very happy that you're still part of the "community" and very happy to "see" you...

DonaldW (12/20/2007)

---

GilaMonster (12/19/2007)

---

Jeff Moden (12/19/2007)

---

I didn't know how long it originally took and, like the bumble bee who doesn't know it's not supposed to be able to fly, I rewrote...

You bet... let me know how it works out for you. And thanks for the feedback.

Actually, those are pretty good links... Thanks, Steve.

Heh... you've all probably seen me post this before... Interviews with people who claim to be experts at T-SQL usually stink. In particular, I had one guy with (supposedly)...

Heh... You forgot some.... 😀

Protect the data, at all costs.

Protect the server the data is on, at all costs.

Help most developers tune queries while teaching them what good set based...

... and don't panic... hit the books on those areas that you're light in... remind the future employer that your resume said "developer" and that you've got some boning up...

FP (8/8/2007)

---

Okay. I'll try that and get back to you guys. Thanks for all of you participated.

True Love is Like A Ghost. Everyone Talks About It & Nobody have seen...

Not that it matters, but I really like the BCP method... it's pretty darned fast, too. As Adam mentioned, it call also capture the bad rows in a separate...

EXEC sp_Help tablename

Funny how things work out... the original poster ended up helping a rider 😉 Nicely done, Hilderman!

Want a great answer that's actually been tested to work... quickly? Then read this, please...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

What were the "tweaks"?

P.S.

Technically speaking, the LEN() example does, in fact, come up with the WRONG answer if you are looking for precisely 3 digits...

Heh... no need :blush: ... dunno what I was thinking about, but I was wrong... the LIKE will use and Index Seek... the LEN will not... here's the code...

DROP TABLE...