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

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 09/23/04

  • Next message: Juan Carlos Hidalgo Macré: "Query can not be executed in SQL Enterprise Manager Query Designer on W2000 Serv" 
    Date: Thu, 23 Sep 2004 14:44:10 -0500

    You can try the following expression:

    LEFT( c, LEN( c ) - PATINDEX( '%[1-9]%', REVERSE( c ) ) + 1 )

    : where c is your column 

    -- 
Anith
  • Next message: Juan Carlos Hidalgo Macré: "Query can not be executed in SQL Enterprise Manager Query Designer on W2000 Serv"