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