Rediger

Del via

Casting the Data Type of a Column

  • Artikkel

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)

Data Type Mappings