SQL and embedded carriage returns

[henrybluebottle]

Thanks.
It would be an ongoing query but only once every couple of months. Not a large file so timing isn't an issue, and it's a vendor's database so couldn't play with indices etc. I'll try your solutions when I'm back at work late next week.