This expression is useful in the manipulation of the BINARY data type as it forces the data type of the expression to convert to BINARY. No additional data type checking or data conversion is performed.

 

Example:

SELECT CNXFORCEBINARY (CharacterField) from MyTable

The above syntax converts the column CharacterField to binary. It does not assume that the character field is a hexadecimal representation of a binary field.