The collation is Latin1_General_CI_AS, but I've created a function that camel cases the input, so the test needs to check the casing.

the rest of my test code looks...

Thanks, but I am trying to do this using the tSQLt testing framework. I guess I can work around  it, by saving the result of the above and asserting a...

I adopted this convention about 3 years and have since managed to introduce it to 2 new companies, it makes a world of difference when deploying code in tightly controlled...

I'm currently working on a warehouse where someone decided it was a good idea to use numeric(2,0) for a cancellation code, works fine for the current system, but now breaks...