Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MrWilliams
Starting Member
1 Post |
 Posted - 2012-01-25 : 12:35:16
|
| Hi guys,I’m a bit stuck on somethingThe French way of writing £69.69 is 66,69I need a way in SQL server to return 66.69 for this valueI have tried:select CAST('66,69' as money)but this returns 6669.00 – not the desired outputReplacing the , with a . is not a solution because that won’t work for all currency formats (it needs to work for all regional settings not just FR).Any ideas?Thanks for any helpSimon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Converting foreign money strings