OK...my issue again....sloppy typing. I had an nvarchar type vs. varchar type...sorry.

Dwain's solution does run however it returns double the number of rows from my original table and takes 36:37 to run vs. 8 minutes. Not sure what the difficulty is here as Dwain's solution is not cursor like and I would have expected much better run times.

Thank you again to Dwain.