new2thegame
Programmer
Could someone please tell me how to encrypt and empty string in the below code:
CASE
WHEN field = 'USA' THEN EncryptByKey(Key_GUID('Supplimental_01'),'') end
The original statemen would be:
CASE
WHEN field = 'USA' THEN '' END
I need the result to encrypt the '' and with the way I have it written, it returns 'NULL'
Any help would be greatly appreciated!!
Thanks!!
CASE
WHEN field = 'USA' THEN EncryptByKey(Key_GUID('Supplimental_01'),'') end
The original statemen would be:
CASE
WHEN field = 'USA' THEN '' END
I need the result to encrypt the '' and with the way I have it written, it returns 'NULL'
Any help would be greatly appreciated!!
Thanks!!