Home Forums SQL Server 2008 T-SQL (SS2K8) Need Alternate Solution RE: Need Alternate Solution

  • January 22, 2013 at 2:32 pm

    #1579835

    sqlbi.vvamsi (1/22/2013)

    this should suffice

    declare @mn money=-1000000

    select replace(CONVERT(varchar(50),@mn,1),'.00','') as mn

    No, that's "Western" format. The OP requires Indian format. This Wiki article gives a good explanation.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]