VARCHAR

Returns a varying length character-string representation of the first argument. Valid types are:

Character string if the first argument is any type of character string

Graphic string if the first argument is an UCS-2 graphic string

Integer number if the first argument is a SMALLINT, INTEGER, or BIGINT

Decimal number if the first argument is a packed or zoned decimal number

Double-precision floating-point number if the first argument is a DOUBLE or REAL

Example:

Make EMPNO varying-length with a length of 10.

  SELECT VARCHAR(EMPNO,10) 
   FROM EMPLOYEE