Re: Currency Format with Comma Delimination

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 06/02/04

  • Next message: Kishore: "Script generation problem" 
    Date: Wed, 2 Jun 2004 07:16:30 +0530

    Use CONVERT function to do this.

    Try something as:

    SELECT '$'+ CONVERT(VARCHAR(50), money_column, 1) AS column_name
    FROM <table> 

    --
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com
  • Next message: Kishore: "Script generation problem"