Phil,

I found my problem -- the goofy character at the front of the keyboard!   The problem was I didn't have the fields in...

Phil,

You're right, there has to be something else going on.  That all works fine and is the same thing I think my code is doing, just simplified.  Obviously I am...

I have tried casting the expression every way I can think of, and no joy.  The Period column is defined as CHARACTER(3) in BaseTable and CHARACTER(2) in ArchiveTable.  Can you...