Click here to Skip to main content
12,397,027 members (68,616 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL MySQL
I have MySQL table with following columns...

TaxType1 var-char(20),
Max Wage-limit decimal(14,2)
Rate decimal(8,6)


In above table,I am stored the values of front end application .Here "Rate" column want to accept 6 digits after "dot"
Eg:10.568971 accept

That why I am putting the decimal(8,6) up-to now, no problem at all,but I want display same data in the front end application grid view ,I am shown these data comfortably.

The following situation like user enter
"Rate:" 10 but it store foramt of 10.000000
20.10-->20.100000
1-->1.000000
But same data is display in grid-view "it like in-comfort"

here I want to trim zero of unwanted


I want these format only.
10.00
20.10
50.10

like that if any value like

1.245789 i want display as it is
and also
1.589000 display in 1.5890

like that I want trim the zeros of table at the time of selection.
Posted 2-Jul-13 21:07pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

SELECT TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from yourfield)) AS yourfield
FROM yourtable
WHERE yourfield LIKE '%.%
 
Yourfield: table  column name
yourtable: table name.

I am find solution in stack overflow
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 3 Jul 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100