Thank you for the reply. I actually through the bit with the middle initial in as a side problem. :blush:

Client sent date with first name and middle name in the same column even though they had a middle name column.

I have not yet create a temporary table for the split or gotten permission to split in the permanent table. Working on it.

Thanks again.