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:

                   

Comments are closed.

Sorry, the comment form is closed at this time.