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 Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------