SHA256

All functions > STRING > SHA256

Returns the SHA-256 hash of a string as a 64-character hexadecimal string.

Signatures

Returns: 64-character lowercase hexadecimal SHA-256 hash

SHA256(string: VARCHAR) → VARCHAR

Notes

• Returns a 256-bit hash as a 64-character lowercase hex string
• Deterministic: same input always produces the same hash
• Suitable for integrity checks and non-reversible identifiers
• Returns NULL if the input is NULL

Examples

SELECT
    f1 := SHA256('ABC'),  -- Hash of uppercase string
    f2 := SHA256('hello'),  -- Hash of lowercase string
    f3 := SHA256('')  -- Hash of empty string
;