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 |
|
lucasql
Starting Member
4 Posts |
 Posted - 2002-10-21 : 05:54:08
|
| Hi, could you help me for this problem? ( With this i Could solve the previous problem)I may use a select with a value with commaexample:select * from test where field1=1,1(field1 :float)How i can do?thank youby luca from Italy |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-10-21 : 06:22:28
|
| Hi!In SQL server the decimal separator is always '.', regardless of your regional settings. select * from test where field1=1.1 will do the trick, just remember that comparing floats in this manner can give you unexpected results. |
 |
|
|
lucasql
Starting Member
4 Posts |
Posted - 2002-10-21 : 06:34:23
|
| Thank you for the answer.I know that decimal use '.', but if I would do a query where the value is 1,2 (without use function like replace..) , How can I do?I think that is impossible without substitute the ',' with '.'by luca |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-10-21 : 07:48:45
|
quote:
How can I do?
You should pass the proper arguement to your DML. 1,1 means nothing to SQL Server. '1,1' is a string, but still not a float. Give you dml a float to begin with or do the necessary conversion and replacement on the string.Jay White{0} |
|
|
|
|
|
|
comma in select