The following hashing function require any parameter string to be casted into varbinary first. The you can apply any hashing function and transform it into hex to be a string and lower it.

SHA512 

SELECT LOWER(TO_HEX(SHA512(CAST('your_string' AS VARBINARY))))

-- 7be98ae8208cafe0392b5b54ad86d40f5de3934bb82228c19d9697682785ac0a4fb9522bf28c6ec9db835318f21a9f7dde2855f0f4a907868074b5729792b6c4

SHA256 

SELECT LOWER(TO_HEX(SHA256(CAST('your_string' AS VARBINARY))))

-- e10207f241d66a8c5f8202ed9fc22b94c031850dd54d8b03fdd40db4cbde5bfc

MD5 

SELECT LOWER(TO_HEX(MD5(CAST('your_string' AS VARBINARY))))

-- 1f656879d9228b4b16e139d3c758f766