Michael - thanks again this worked with some slight modification.

I have been formatting my SQL data to a string format that I thought Oracle would like so I had...

Thanks for this I will give it a try and post if it works.