Glad to see a basic question sparked a bit of healthy debate!

Thanks for your help guys. I had got it right originally in the way Jonathan's first script shows, using convert. The thing that threw me and made me think it...

Thanks Jonathan,

Your script works and I'd tried the convert on several individual dates in that column and it works, but if I run the query against all of the data...

Amazing what an hour's thought can do. Have figured it out. Probably not the most efficient way of doing it but it works!! Code below if anyone's interested.

Declare #cursor cursor...