>Your right, one of the fields had a different length. So much for trusting the word of others....Thanks again.

Kirk --

And what I'm sure you're about to do, for the benefit of curious lurkers, is to use a LEFT (myLongerField, LengthOfShorterField) as an expression in the appropriate SELECT, to get those field lengths in sync.

Jay