Aggregate FunctionsMAXMINCOUNTSUMAVGConversion FunctionsCAST and CONVERTCOALESCETRY_CONVERTCryptographic Functions: HASHBYTESDate and Time FunctionsGETDATEDATEADDDATEDIFFDATEPARTISDATELogical Functions: IIFString FunctionsCHARINDEX and PATINDEXLENLEFT, RIGHT, and SUBSTRINGLTRIM, RTRIM, and TRIMLOWER and UPPERREPLACE and TRANSLATEREVERSESTRING_AGGSystem FunctionsISNULLISNUMERICFinal Thoughts on Functions