Re: Using AES_DECRYPT displays NULL

[Peter Kaye]

Some wise person from the Utter Access forum pointed out that the data for decrypting is binary not string. Therefore no single quotes.

This works as it should...

SELECT CAST(AES_DECRYPT(e570ca3c339299069727ba6d33fec255, 'y') AS CHAR);