|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/31/2006 9:31:00 AM
Posts: 4,
Visits: 1
|
|
Hi,
I am a newbie and just trying a simple thing which I am finding hard to do. I want to format the output and see the formatted result. I used to write this command in Oracle but it doesn;t work here:
column check_status format a50;
where check_status is the name of the column. Can somebody tell me what is the exact command?
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Yesterday @ 4:20:22 PM
Posts: 327,
Visits: 504
|
|
Use CAST function within your SELECT, e.g.
CAST(check_status AS CHAR(50))
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/31/2006 9:31:00 AM
Posts: 4,
Visits: 1
|
|
|
Thanks Fred...I realised it is very difficult to change the attribute characteristics in teradata....
|
|
|
|