Q:

How can I allow users to enter commas in a value that will be stored in an sql server 2005 numeric field?

I have a table field whose Datatype is numeric(10, 1). This field stores the AmountPaid and the user prefers to enter the Amount Value with commas in between like 78,234,673 because that's what they're used to, otherwise they will making a lot of errors.
Is there a way I can allow commas in the value but remove them when saving, or is there a way I can go ahead and store them in SQL-SERVER without changing the DATATYPE?

A:

Double.Parse(TextBox1.Text) is what i was looking for.

