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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for