Is that going to be their Y2K dilemna?

I tend to overestimate when designing table schema and using varchar or nvarchar if it's not max. So I agree Steve, that if I have an invoice column and the...

Lynn,

That worked perfectly. Hours spent trying to do this to have you solve it in seconds. I guess that is why I am posting in the newbie section!

I will create...

What originally happened was the current table was updated without using the proper join constraint, this wiped out all of the records in one of the columns.

Right after that, the...

I'll try to be more clear:

We have a table, lets call it Automobiles. We also have a backup table of Automobiles before it was modified, called AutoB. In both tables,...

Maybe my intuition was wrong, but my thought process was:

1. If I query two tables for their non blank columnZ, and tableA has 883 more non rows of that non...

These are excellent. I'm a bit embarrassed two of these were on this site. I'll search more next time. Thanks!