danyschaer wrote:

> 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
>

cast does not use regional settings, you will need to do it on the fly.

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br