Thanks. That makes sense. How do I go about managing the flow control then?

This is probably just a button for me, but I'd like Ryan to stay away from single letter variables. 'i' and 'q' don't tell me that much. Even if...

Thanks Jay. It worked really well.

On a similar note, if my SQL 7 database is set up to be case insensitive, how would I go about checking whether a column is all upper case or...

There was an article by Steve Jones, called Tame Those Strings, Part 7, that probably needs to be only slightly modified for what you're trying to do.

http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp

I would really love to. Unfortunately, the database is a little old: SQL Server 6.5.

I can't tell you how many queries I've rewritten to dumb them down.

That did it. Thanks very much.

I have a possible solution, but its pretty ugly and uses a number of temporary tables. Can someone think of a more elegant solution? I'm a big fan...

The columns are:

Site.CreateDate

Site.DateChgd

Contact.CreateDate

Contact.DateChgd

Opportunity.CreateDate

Opportunity.DateChgd

There is a 1 to many relationship with Site being the parent table for Contact and Opportunity.

All tables have the InternalID column...