Edytuj

Udostępnij za pośrednictwem

Casting the Data Type of a Column

  • Artykuł

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