danyschaer wrote:

> 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

select fff
from ttt
where cast(
SUBSTRING(fff from 1 for STRPOS(',', fff) - 1)||'.'||
SUBSTRING(fff from strpos(',', fff)+1 ) as float) > 100


--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com