>Instead of SELECT *, you might explicitly list all the fields: SELECT Field1, Field2, left(Field3, 2) as Field3, assuming the problematic field is called Field3.

Thanks, I know I could do that, but I am trying to avoid it from a maintenance POV. This is now a generic routine and I don't want the layouts of these six tables hard coded into it.

Mike