How to convert commas into periods?

[Pheddy]

Hi All.
I have a Local Hardware distributer that sends me prices in comma values like 313,00 (European) but my system deals with US-EN Payment gateways so I'll need to convert the entire column from xxx,xx to xxx.xx (Data type is: decimal(13, 2)) That is the Comma to Period without changing the Price value.

Is there a way to do this by SQL Commands?

Regards and Thanks.
Frederik

[yarbrough40]

SELECT REPLACE('Hello,World',',','.')

the result is Hello.World

[Pheddy]

Would you know how to use wildcards, if the "Hello" and "World" isn't known?

[yarbrough40]

substitute the Hello World with your column name