Subject | cast 'nnn,nn' to float |
---|---|
Author | danyschaer |
Post date | 2008-11-27T19:54:09Z |
Hi all;
I am working with a table that have into varchar fields some floating
values, but they use a comma as decimal separator (regarding regional
settings).
Is it possible to cast this values to floating point values?? ... so I
can run filters like:
select fff from ttt where cast(fff as float) > 100
Thanx.
Dany
I am working with a table that have into varchar fields some floating
values, but they use a comma as decimal separator (regarding regional
settings).
Is it possible to cast this values to floating point values?? ... so I
can run filters like:
select fff from ttt where cast(fff as float) > 100
Thanx.
Dany