@BINARY
Use the @BINARY
function when a source column referenced by a column-conversion function is defined as a character column but contains binary data that must remain binary on the target. By default, binary data in a character column is converted (if necessary) to ASCII and assumed to be a null-terminated string. The @BINARY
function copies arbitrary binary data to the target column.
Example
The following shows how @BINARY
can be used to copy the data from the source column ACCT_CREATE_DATE
to the target column ACCT_COMPLAINT
.
ACCT_COMPLAINT = @IF ( @NUMBIN (ACCT_CREATE_DATE ) < 48633, 'xxxxxx', @BINARY (ACCT_COMPLAINT))