Encrypting a column to compare with an encrypted column on select query

Can I receive assistance, please?

I have the below query where I'm doing a LEFT JOIN between 2 tables. For the ON columns, one value is encrypted and the other isn't. Is there a way to use "hash("sha256", zCIFRecord.CIFPan);" to encrypt zCIFRecord.CIFPan so I can compare?

zCIFRecord.CIFPan = CIFExtraInfo.PanHash


select CIFExtraInfo.Email,zCIFRecord.RecordId,zCIFRecord.CIFPan,zCIFRecord.CIFAcctNum1,
CONCAT(zCIFRecord.CIFFName, ' ', zCIFRecord.CIFLName) AS name,zCIFRecord.CIFCIFPhone,zCIFRecord.CIFExpDate,
zCIFRecord.CIFUpdateActivity,zCIFRecord.CIFUpdateDate,zCIFRecord.CIFCardStat,CIFUserId,CIFDateTime,
row_number() over(partition by zCIFRecord.CIFPan order by zCIFRecord.CIFDateTime desc) as row_num from zCIFRecord LEFT JOIN CIFExtraInfo ON zCIFRecord.CIFPan = CIFExtraInfo.PanHash)

Any assistance provide will be appreciated.

SHA2(zCIFRecord.CIFPan, 256) = CIFExtraInfo.PanHash

Thank you, Ray.

I'm getting the below error. Apparently, SQL doesn't like SHA2 in the query.

DataTables warning: table id=carddetails - An SQL error occurred: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'SHA2' is not a recognized built-in function name.

SQL Server? Yes, that is a MySQL function. I didn't realize you were using SQL Server.

In SQL Server databases I think the syntax is:

HashBytes('SHA2_256',zCIFRecord.CIFPan) = CIFExtraInfo.PanHash

Thanks, Ray.

I'll take a look.