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

2007-12-08 Thread Mag. Wilhelm Braun 

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.2008999" and not "4.0"


select max(cast(txt as real)) from test;

Igor Tandetnik

- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 







-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

2007-12-08 Thread Igor Tandetnik 

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