62,264
社区成员
发帖
与我相关
我的任务
分享

SELECT F_CustomerId ,CAST(AES_DECRYPT(unhex(F_MobileEncryption), '**********') AS CHAR(50)) AS F_MobileDecrypt
,CAST(AES_DECRYPT(unhex(F_Mobile2Encryption), '**********') AS CHAR) AS F_Mobile2Decrypt
,CAST(AES_DECRYPT(unhex(F_Mobile3Encryption), '**********')AS CHAR) AS F_Mobile3Decrypt FROM lfine_crm_customer