Returns the password hint if one is found in the data encrypted by the ENCRYPT function. A password hint is a phrase that will remind data owners if they forget their password. The result of the function is VARCHAR(32) if a hint was provided, or null if no password hint was included in the ENCRYPT function.
Example:
The hint 'George' is stored to remind the user of the encryption password 'WASHINGTON'.
INSERT INTO EMP (SSN) VALUES ENCRYPT ('289-46-8832', 'WASHINGTON', 'George'); SELECT GETHINT(SSN) FROM EMP;
The value returned is 'George'.