Re: [sqlite] Re: Is there a way to do comparison of text in a numerical way.

Thanks Igor Tandetnik great help. W.Braun Igor Tandetnik wrote: Mag. Wilhelm Braun <[EMAIL PROTECTED]> wrote: is there a way to do comparison of text in a numerical way. EXAMPLE rows:Column txt "0.200899" "1.2009" "113.2008999" "4.0" "3.1" SELECT max(txt) FROM test should return "113.2008

[sqlite] Re: Is there a way to do comparison of text in a numerical way.

Mag. Wilhelm Braun <[EMAIL PROTECTED]> wrote: is there a way to do comparison of text in a numerical way. EXAMPLE rows:Column txt "0.200899" "1.2009" "113.2008999" "4.0" "3.1" SELECT max(txt) FROM test should return "113.2008999" and not "4.0" select max(cast(txt as real)) from test; Igor