CAST Function

Starting with Denodo 5.5, the function CAST truncates the output when converting a value to a text, when these two conditions are met:

  1. You specify a length for the target data type
  2. And, this length is lower than the length of the input value.

For example, CAST ("Denodo" AS VARCHAR(2)) returns “De” because the target type specifies a length lower than the length of the input value.

In Virtual DataPort 5.0, the behavior of the CAST function can be altered to avoid truncating the value. In later versions, the behavior of the CAST function cannot be altered and it always truncates strings if necessary.