My db has a table with a column defined thus:
body_size text default '0.0'
whose purpose is to hold the size of the item that the row represents. All rows
contain a value but as a string to one decimal place, not a number. So the
column contains strings such as '0.0', '3.7', '22.9', etc. All
pated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Tim Streater
>Sent: Thursday, 17 May, 2018 15:42
>To: SQLite mailing list
>Subject: [sqlite] Function to use to convert a text float to a flo
; lot about anticipated traffic volume.
>
>
>>-Original Message-
>>From: sqlite-users [mailto:sqlite-users-
>>boun...@mailinglists.sqlite.org] On Behalf Of Tim Streater
>>Sent: Thursday, 17 May, 2018 15:42
>>To: SQLite mailing list
>>Subject: [sqlite] Function
On 17 May 2018, at 23:13, Keith Medcalf wrote:
> select col1, col2 from mytable order by cast(body_size as float);
Thank you. That's much better (although abs(body_size) worked too).
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mai
4 matches
Mail list logo