ChrisM@Work although with the initial semi clean data I provided it appeared your query did the trick but once placed into the live environment it did not catch all of...

Initial testing this appears to be the answer. I am waiting on my testing server to catch up to me, once I perform some tests I will respond on the...