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

 

Example:

SELECT CNXFORCECHAR (BinaryField) from MyTable

 

The above syntax converts the column BinaryField to character. It does not attempt to convert the binary field to a character hexadecimal representation.