• For a specified data type and set of values, this function returns  true  or  false . 
• Inputs can be literal values or column references.

You can use the ISVALID  function keywords interchangeably.

• You can define a conditional test in a single step for valid values. See IFVALID Function.
• This function is similar to the ISMISMATCHED function, which tests for mismatches against a specified data type. However, the ISMISMATCHED function also matches against missing values, while the ISVALID function does not. See ISMISMATCHED Function.

Column reference example:

Output: Returns true when the value in the Qty column contains a valid Integer and the value is greater than zero. 

Column reference example for Datetime:

The Datetime data type requires a special formatting string as part of the evaluation of validity:

Output: Returns true when the value in the myDates column conforms to either of the following date format strings:

yy-mm-dd hh:mm:ss
yyyy*mm*dd*HH:MM:SSX

For more information on these and other date format strings:

• Datetime Data Type
• DATEFORMAT Function

Numeric literal example:

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

column_string

Name of the column or string literal to be evaluated for validity.

• Missing literals or column values generate missing string results.
  • Constants must be quoted ('Hello, World').
• Multiple columns and wildcards are not supported.

datatype_literal

Literal value for data type to which to match the source column or string. For more information, see Valid Data Type Strings.

• Column references are not supported.

Valid data type strings:

Example - Type check functions