Re: how to suppress zeroes after decimal and whole no. should remain same

From: Steve Kass (skass_at_drew.edu)
Date: 09/26/04

  • Next message: Steve Kass: "Re: how to suppress zeroes after decimal and whole no. should remain same" 
    Date: Sun, 26 Sep 2004 01:08:49 -0400

    Not quite. This will format 3000.000 as '3' .

    SK

    Anith Sen wrote:

    >You can try the following expression:
    >
    >LEFT( c, LEN( c ) - PATINDEX( '%[1-9]%', REVERSE( c ) ) + 1 )
    >
    >: where c is your column
    >
    >
    >

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