Heheeeee. I got mad props from my customer 🙂

I couldn't in good conscience take all the credit

opc.three you got it; hence, you got the problem. Two things I want to stress:

I did come up with a solution but it was very ... ugly and worked...

BTT

Below is the DDL. I should explain that the matched field column means the to customers matched on either their Drivers License Number (DLN); Last 4 of their Social...

I started out my non-mainframe programming with condensed basic (think TRS80); moved to the Mainframe where I did COBOL / CICS / DB2 / Assembler and numerous other languages and...

See I got it wrong for two reasons:

I was a knuckle head and missed the "English only" so yes varchar or char. The choice between the two...