ASCII ProperCase Function

Another ProperCase function that utilises the ASCII function

HashBytes Nvarchar(MAX)

SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets.

Solution

Expose the C# Hashbytes function using CLR