Casting the data type of a column

At times you may need to cast string data extracted from documents as another data type, so that an appropriate comparison can be made. Cast an identifier or literal as another data type using the following syntax:

CAST (<identifier> | <literal> AS <datatype>)

For example:

CAST ('10000' AS DBTYPE_I4)
            
CAST (System.DateCreated AS DBTYPE_WSTR)

Related topics

Data Type Mappings