Re: how to suppress zeroes after decimal point at the end in a value

From: hari (anonymous_at_discussions.microsoft.com)
Date: 09/23/04

  • Next message: hari: "how to suppress zeroes after decimal and whole no. should remain same" 
    Date: Thu, 23 Sep 2004 01:17:03 -0700

    hi thanks,

     but it is not working for whole number like ex:11120
     it is giving it as 11120. (with point at the end)
     how to do that.

    thanks,

    hari.
    >-----Original Message-----
    >see following example:
    >
    >drop table test
    >create table test(c1 decimal (15,5))
    >insert into test values (3.567000)
    >insert into test values (232233.567000)
    >insert into test values (3.567)
    >
    >query:
    >select c1,reverse(substring(reverse(cast(c1 as varchar
    (25))) ,
    >patindex('%[^0]%', reverse(cast(c1 as varchar(25)))) ,
    >len(cast(c1 as varchar(25))) - (patindex('%[^0]%',
    reverse(cast(c1 as
    >varchar(25)))) - 1)
    >)) 'no_zeros'
    >from test
    >
    >--
    >Vishal Parkar
    >vgparkar@yahoo.co.in | vgparkar@hotmail.com
    >
    >
    >.
    >

  • Next message: hari: "how to suppress zeroes after decimal and whole no. should remain same"