Jeff, I warned Fox he would hear about triangular joins one day.

Let us get the man weaned off cursors first !! 😉

I didn't know it was POSSIBLE to be off-topic when posting to The Thread.

Thanks, Flo. I am going to hold time trials tonight.

Hope you have a good evening. 🙂

Thanks guys. 🙂

I'm aware of SOUNDEX. The problem is that some of these strings aren't names, or even proper words, so I eliminated that...

Rob, I thank you for the compliment, but I must redirect the credit where it truly lies.

I thought I was fairly good at SQL until I started...

The normal application will be a comparison between two tables, with a table of several thousand being compared to a table of 75,000 and growing.

I am coding as we chat...

Unfortunately CLR isn't an option for me for the same reason that front end editing isn't. Long story.

As for fuzzy lookup, I haven't looked at it for a...

ONLY page 30??? 😛

Had the real madness even begun by that point? Time to try out DBCC TIMEWARP.

If...

I certainly don't hold a grudge about him calling Lynn "dense". 😛

... even if he did miss that offsides call.

Hey Ref, open your eyes... you're missing a...

Hey Guys... don't hijack the thread. We're in SQL 7,2000 here.

Please take further discussion over to an SQL2k5 thread. It's a good...

Steve, I won't ask about the balls, but do ruggers really eat their dead?

Those are the only qualifications I have, Greg. ...

Lynn, I didn't mean for my explanation to come over the top of your code. I just took a while to think about it and type it...

Thanks Derek. I hadn't had the time to do that, and couldn't have improved on it.

Fox, if you look at that last code you will see that...

I was just coming here to post the same thing, Lynn. Although not a Jedi yet, it may be that he has turned from the Dark Side....