numeric data

This is a really stupid question, but I've never dealt with it before. How
does one insert or update numeric data with commas in it?
col = numeric (6,2)
In an english database, you can simply remove the commas and all is well.
insert into table (col) values (1,200.34)
would be
insert into table (col) values (1200.34)
In some european countries, the comma is what we use for the period. So,
1.200,34 is equal to 1,200.34 in the USA.
but, the following will of course not work, even if you run the command "SET
LANGUAGE 'German'" on the database first.
insert into table (col) values (1.200,34)
How do you get around this issue?
Thanks!select replace(replace('1.200,34', '.', ''), ',', '.')
To get around this problem,
since I have English and French users for my Web pages,
I have two fields for the user to fill when entering Numeric values.
In your example, the user would enter 1200 in 1 field and 34 in the other.
I simply don't accept commas and periods.
Then I format the number before sending in to the database.
"Jon" <rosenberg@.mainstreams.com> wrote in message
news:9a444$42e8eb3b$438dcb39$29441@.ALLTE
L.NET...
> This is a really stupid question, but I've never dealt with it before.
> How does one insert or update numeric data with commas in it?
> col = numeric (6,2)
> In an english database, you can simply remove the commas and all is well.
> insert into table (col) values (1,200.34)
> would be
> insert into table (col) values (1200.34)
> In some european countries, the comma is what we use for the period. So,
> 1.200,34 is equal to 1,200.34 in the USA.
> but, the following will of course not work, even if you run the command
> "SET LANGUAGE 'German'" on the database first.
> insert into table (col) values (1.200,34)
> How do you get around this issue?
> Thanks!
>