Hey Shi Zhong,
Below is an example.
values(replace(ltrim(rtrim(replace(char(000036.47),'0',' '))),'','0'))
It's Fridayyyy! Partyyyyy! Hehe.
Have a great day and Weekend!
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Shi Zhong
[mailto:db2udbdba-ezmlmshield-x36361329.[Email address protected]
Sent: Friday, April 27, 2007 3:28 PM
To: LazyDBA Discussion
Subject: Best Way to Get Rid of the Leading Zero
Guru,
I need the FREE column to be character but don't want the leading zero.
What is the best way to do it in SQL?
db2 "select substr (tablespace_name, 1, 18) as tbsname, char (dec
((float (free_pages) / float(total_pages) * 100), 8, 2)) as "Free" from
TABLESPACE_CFG
TBSNAME FREE
------------------ ----------
BC_0201_DT 000036.47
BC_0201_IX 000027.39
BC_0202_DT 000013.84
BC_0202_IX 000024.52
BC_0301_DT 000011.10
BC_0301_IX 000021.96
BC_0302_DT 000012.09
BC_0302_IX 000022.26
Thanks.
Zhong
FCSO DBA
First Coast Service Options, Inc., and its affiliates are not
responsible for errors or omissions in the transmission of this e-mail
message. Any personal comments made in this e-mail do not reflect the
views of First Coast Service Options, Inc., or its affiliates. The
information contained in this document may be confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. This document may also contain material that is privileged or
protected from disclosure under applicable law. If you are not the
intended recipient or the individual responsible for delivery to the
intended recipient, please (1) be advised that any use, dissemination,
forwarding, or copying of this document IS STRICTLY PROHIBITED; and (2)
notify sender immediately by telephone and destroy the document. Thank
you.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page