Below are 10 SQL Server functions that are hardly used but should be used a lot more.
This post explains how they can be used. Good stuff!
BINARY_CHECKSUM
SIGN
COLUMNPROPERTY
DATALENGTH
ASCII, UNICODE
NULLIF
PARSENAME
STUFF
REVERSE
GETUTCDATE
