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
3. After inserted into the database, I convert the number to
dollar sign to show on the screen.