0 Replies Latest reply on Jun 21, 2007 9:56 AM by HandersonVA

    dollar input and output

    HandersonVA Level 1
      I try to allow people to input a dollar sign ($) and minus (-), and comman(,) symbols on the curreny user input box and they will see what they input on the screen as an ouput. However, money data type in the ms sql 2000 won't accept those symbols. Also, I need to give a user validation message if they enter a wrong format on the curreny field. Can anyone give me a direction to prevent and show what I described here.
      what I tried as below, but it didn't work that I expected.
      1. I set data type in sql2000 as "money"
      2. in order to store a value what user enteres with dollar sign and comman, i convert them to numberformat and put it into database.
      3. After inserted into the database, I convert the number to dollar sign to show on the screen.

      Can anyone advise me what I did wrong? thanks.