RE: Best Way to Get Rid of the Leading Zero

RE: Best Way to Get Rid of the Leading Zero

 

  

That is what I looking for.

Thanks.

Zhong
FCSO DBA
x10208

-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x28870667.[Email address protected]
Sent: Friday, April 27, 2007 3:52 PM
To: LazyDBA Discussion
Subject: RE: Best Way to Get Rid of the Leading Zero

values(replace(ltrim(rtrim(replace(char(01230045.12345),'0',' '))),'
','0'))

--This will cause get rid of all the trailing and leading zeros





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


---------------------------------------------------------------------
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






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.


DB2 & UDB email list listserv db2-l LazyDBA home page