Problem: Comparison uses trailing zeroes when comparing binary and varbinary datatypes.
Possible cause: When two binary columns are being compared, one column value has one or more trailing zero bytes (0x00) the other column value does not. DA always ignores trailing zero bytes to enable padded binary values to match varbinary values.
Solution: There is no workaround for this problem.