Hey Jeff,

I think you're method is pretty close to what I need. The only difference I see off the top of my head is that the WHILE...

Guys,

Thank you for correcting me.

A company I used to work for hired a sql guy to teach us about Sql 2k when it first came out. ...

I agree with Colin (also, trying not to be rude). SQL Server is not like MS Access.

Good luck!

Chris.

I don't believe you'll see a performance issue at all when comparing varchar's of various lengths.

My understanding, and I'm sure someone will correct me if I'm wrong, is that sql...