MYOB Exo – Useful SQL Server Scalar Functions

The following are a collection of User Defined Functions I’ve found variously on the Internet. I use these extensively now to do simple data transforms when pulling reports, such as converting all line breaks to pipe characters so that copy/paste into Excel works nicely. Behind the cut I’ve got several functions, and they’re all wrapped […]