The BINARY function returns a BINARY representation of a string of any type. The result of the function is a fixed-length binary string.
Example:
The following function returns a BINARY for the string 'This is a BINARY'.
SELECT BINARY('This is a BINARY') FROM SYSIBM.SYSDUMMY1