I take it that the lack of response mean 'we don't know' 🙁

Before I give up, can someone tell me if it's possible to move this post into the T-SQL...

Double post

Thanks for the responses. I've used the version started by Gianluca Sartori and slightly adjusted by GSquared to give me perfect results. I'll live with passing null values into the...

Both do the job nicely and are MUCH simpler than anything I was coming up with (although the second has the consequence that it converts 'fish; & ; chips' into...

Thanks for the views. I guess that I will make them individually then.

Thanks

Stuart