This function gets a type from an expression that can contain a composite type. If the expression contains a type other than the required type, it returns NULL.


  • Expression.
  • Type. A string containing the type string. For example, Number, String, and so on. In addition to primitive types, the string can also contain a table name. In this case the function attempts to cast to a reference to that table.

CAST(Data.Attribute1, "Number(10,3)")