November 24th, 2008
CAST (convert data type), Part 3 of 3
Posted by
admin in
G. ANSI Scalar Functions
Here is an example:
SELECT (CAST(QTY AS CHAR(3)) || ' units sold of ' || INVN_ID)
FROM SALES_TBL;
Results:
                   
