My requirement is to write a sql code to replicate the MD5 Logic used in informatica expression transformation for Validation Purpose . The MD5 used in Informatica is MD5(TRIM(AGRMNT_NO)||TRIM(SRC_CD)) . I tried Writing the Logic in sql as shown below but it keeps throwing error .

SQL_CODE :

SELECT
    STANDARD_HASH(AGRMNT_NO || SRC_CD)
FROM
    EODS_STG.STG1_EODS_BACC_POLICY
WHERE
    STG1_EODS_BACC_POLICY.BACC_PR_TYPEX IN ('OR','AN')