BINARY

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