Tests whether a set of values is not valid for a specified data type.

You can define a conditional test in a single step for valid values. See IFMISMATCHED Function.

NOTE: This function is similar to the ISVALID function, which tests for validity against a specified data type. However, unlike the ISVALID function, the ISMISMATCHED function also matches against missing values. See VALID Function.

Column reference example:

ismismatched(Qty, 'Integer') || (Qty < 0)

Output: Returns true when the value in the Qty column does not contain a valid Integer and the value is less than zero.

Numeric literal example:

ismismatched('ZZ', 'State')

Output: Returns true, since the value ZZ is not a valid U.S. State code.


ArgumentRequired?Data TypeDescription
column_stringYstringName of column or string literal to be applied to the function
datatype_literalYstringString literal that identifies the data type against which to validate the source values


Name of the column or string literal to be evaluated for mismatches against the specified type.

Required?Data TypeExample Value
YesString literal or column referencemyColumn


Literal value for data type to which to validate the source column or string.

Required?Data TypeExample Value
YesString literal'Integer'

Valid data type strings:

Example - Type check functions