convert a decimal number into character

karanbikash

hi ,
I have a column with datatype as decimal(31,2) . The data is like
123456.67 , 7634578.99
Is it a way to convert the entire number into character . like
'1232456.67' .

The output should not be like as below :
db2 =select char(decimal(BAL_PRINCIPAL,31,2)) from
BIKASHK.RPT_BA_PAD331 where
integer(Bal_principal)!=0

1
---------------------------------
00000000000000000000010025000.00
00000000000000000000010025000.00
00000000000000000000010025000.00
00000000000000000000010025000.00

4 record(s) selected.

Rather It should be

10025000.00
10025000.00
10025000.00
10025000.00

For the above 4 rows and it should be 'char' in data type.

Appreciate your help .
Best Regards
Bikash Karan

Jun 27 '08 #1

Subscribe Reply

15346

Serge Rielau

ka*********@gmail.com wrote:

hi ,
I have a column with datatype as decimal(31,2) . The data is like
123456.67 , 7634578.99
Is it a way to convert the entire number into character . like
'1232456.67' .

The output should not be like as below :
db2 =select char(decimal(BAL_PRINCIPAL,31,2)) from
BIKASHK.RPT_BA_PAD331 where
integer(Bal_principal)!=0

1
---------------------------------
00000000000000000000010025000.00
00000000000000000000010025000.00
00000000000000000000010025000.00
00000000000000000000010025000.00

4 record(s) selected.

Rather It should be

10025000.00
10025000.00
10025000.00
10025000.00

For the above 4 rows and it should be 'char' in data type.

Just LTRIM or STRIP the leading 0s

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Jun 27 '08 #2

karanbikash

On May 7, 5:34*pm, Serge Rielau <srie...@ca.ibm.comwrote:

karanbik...@gmail.com wrote:
hi ,
I have a column with datatype as decimal(31,2) . The data is like
123456.67 *, 7634578.99
Is it a way to convert the entire number into character . like
'1232456.67' * * .

The output should not be like as below :
db2 =select char(decimal(BAL_PRINCIPAL,31,2)) from
BIKASHK.RPT_BA_PAD331 where
*integer(Bal_principal)!=0

1
---------------------------------
00000000000000000000010025000.00
00000000000000000000010025000.00
00000000000000000000010025000.00
00000000000000000000010025000.00

* 4 record(s) selected.

Rather It should be

10025000.00
10025000.00
10025000.00
10025000.00

For the above 4 rows and it should be 'char' in data type.

Just LTRIM or STRIP the leading 0s

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab- Hide quoted text -

- Show quoted text -

Hi Serge ,

Thanks It worked . I did modified it a bit .

Thanks :)
Regards
Bikash Karan

Jun 27 '08 #3

Similar topics

7075

convert dec number to HEX and oct and bin without c library function

by: whatluo | last post by:

Hi, all I'm now working on a program which will convert dec number to hex and oct and bin respectively, I've checked the clc but with no luck, so can anybody give me a hit how to make this done...

C / C++

5565

convert decimal number in a hexadecimal number ?

by: muss | last post by:

how to convert decimal number in a hexadecimal number using C? Please help me. Thanks.

C / C++

46125

how to convert decimal number to binary

by: saima | last post by:

a program that takes a decimal number input from the user and displays its binary number equivalent in 12 bits on the screen. For example: Enter a decimal number: 32 Its Binary Equivalent is : ...

C / C++

16199

Conversion from Hexadecimal number into Decimal number

by: dharmdeep | last post by:

Hi friends, I need a sample code in C which will convert a Hexadecimal number into decimal number. I had written a code for that but it was too long, I need a small code, so request u all to...

C / C++

2680

Convert decimal number to any base (2-16)

by: ahoway | last post by:

I am working on a program where I have to enter a decimal number and enter a base and it converts according to base. output: Please enter a decimal number to convert: 15 <-input What base would...

C / C++

3566

<faqentry>How do I convert a Number into a String with exactly 2 decimal places?</faqentry>

by: VK | last post by:

http://groups.google.com/group/comp.lang.javascript/browse_frm/thread/ b495b4898808fde0> is more than one month old - this may pose problem for posting over some news servers. This is why I'm...

Javascript

2199

How convert decimal number to hexadecimal?

by: Metalpalo | last post by:

Hello everybody I created small batch file in MSDOS. In this batch file i need to print hexadecimal value of some env. variable. For example: I enter value via command :set /P PAR=Enter...

Microsoft Windows

2000

how to convert decimal number to binary using c

by: marulasiddesh | last post by:

can any one help me out in converting a decimal number to binary number?

C / C++

1939

decimal number into binary number

by: Hets | last post by:

Write a C program which can convert decimal number into binary number.

C / C++

9746

data type for decimal number

by: neha_chhatre | last post by:

which is the best format specifier(data type) if i have to work with decimal number. also please tell me the syntax for truncating a decimal number please reply as soon as possible

C / C++

7221

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7109

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7372

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7029

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5619

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5039

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4702

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3179

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

411

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General