GETHINT

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'.