Quote:
|
Originally Posted by fhussain
SELECT cast(char (OUTSTANDINGBAL) as varchar (30))
FROM CREDITTable;
|
The following does exactly what you want:
Code:
SELECT cast(OUTSTANDINGBAL as varchar (30))
FROM CREDITTable;
(At least, on DB2 v8 for z/OS; don't know about other versions.)