ISENCRYPTED function [System]

ISENCRYPTED( string, key[, algorithm ] )

INT

string The string to be analyzed to determine if it is encrypted. This parameter is case sensitive, even in case-insensitive databases.
key The encryption key used to encrypt the string. This parameter is case sensitive, even in case-insensitive databases.
algorithm This optional parameter specifies the algorithm used when the string was encrypted. Supported algorithms include: AES, AES256, AES_FIPS, and AES256_FIPS.
You can specify one of the FIPS algorithms for algorithm on any platform that supports FIPS.

ISENCRYPTED returns 1 when the input string is encrypted with the specified key; otherwise it returns 0.

The following fragment illustrates the use of the ISENCRYPTED function:

SELECT ISENCRYPTED( ENCRYPT ('test_string', 'key' ), 'key');