Post reply

add $ sign and number to table

  • May 3, 2011 at 8:18 pm

    #389432

    hi

    what data type should i use to add $23,000.000

    thanks

  • May 3, 2011 at 8:26 pm

    #1319505

    Convert the amount column to VARCHAR(x) and concatenate the dollar symbol.. am not aware of any direct methods for that..

  • May 3, 2011 at 9:17 pm

    #1319511

    Should be done client side when presenting the data.

    If this is for some e-mail warning or report then do as CC already suggested.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply