Subject | Re: cast 'nnn,nn' to float |
---|---|
Author | danyschaer |
Post date | 2008-11-28T10:13:40Z |
Hi Michael;
Thank you. I can't change the table, and I can't change the use of
comma to period.
If cast can't work respecting regional settings, I think I have to find
a way to do a conversion on the fly, something like:
select fff from ttt where cast(strtran(fff,',','.') as float) > ...
Dany
Thank you. I can't change the table, and I can't change the use of
comma to period.
If cast can't work respecting regional settings, I think I have to find
a way to do a conversion on the fly, something like:
select fff from ttt where cast(strtran(fff,',','.') as float) > ...
Dany