This is amazing.  Thank you so much,

apologies don't worry about that one just use:  

SELECT c.Dealer, c.ContCode,  CG.Description AS [Attempt], c.RegNo, c.Salute, c.Updated, c.ContDate, c.CompleteCode

Sorry please see below

SELECT c.Dealer, c.ContCode, cp.description, CG.Description AS [Attempt], c.RegNo, c.Salute, c.Updated, c.ContDate, c.CompleteCode

Thanks all much appreciated

Thanks so much for this Jon.  I've have a few joins in the live data is there a way to incorporate what you did above into the below 'Query 1'. ...

Thanks Ken, how is that written into the above? Sorry, still learning.  Many thanks

Amazing thank you very much

Actually, dont worry i'll just use that for each column.  Many thanks for your help

thanks for that - i really need to replace all the commas in all columns i'm assuming this is a little harder to do

Thanks guys much appreciated FORMAT(DateIn,N'MMM dd yyyy') works a treat

Thank you all much appreciated

Amazing Eirikur Eiriksson, it now works fine thank you so much

Thanks for coming back to me. Yeah, its works fine in SSMS and also I import the query into excel and it also works fine.

I'm an idiot, sorry guys

Thank Guys, i've attached some dummy data below.  As you can see the regdates are not older than 5 years

-- Sample data
IF OBJECT_ID('tempdb..#LOGFILE') IS NOT...