In some scenarios (such as using select by attributes or a definition query) a string operation might be necessary, but if the data is a number type it does not work. This article provides a sample of how to cast the number field to a string for a SQL operation.
CAST( "SQLNUM" AS CHARACTER(12))
CAST( "SQLNUM" AS CHARACTER(12)) <> "SQLTEXT"
Get help from ArcGIS experts
Download the Esri Support App