syb3

SELECT
CONVERT(VARCHAR(64),
HASHBYTES(
'MD5',
CONVERT(VARCHAR(255),
CHECKSUM(
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), INTERNINSTID))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), INTERNVERSION))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), INTERNTIMESTAMP))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), INTERNRECTYPE))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), INTERNFIXSTRING))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), ORDERID))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), ACCOUNT))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), MERGEID))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), PARENTORDERID))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), SALESPERSONID))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), SYMBOL))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), EXPIREDATE))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), EXPIRETIME))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), LEAVESQTY))), '') ||
ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), TIMEINFORCE))), '')
)
)
),
2) AS table_checksum
FROM CADECPLSORDER