How To Get Max Value Of Column Type Integer Stored As Type Text In Sqlite Table

I want to get MAX value of one column in sqlite table. The problem is the type of data is long in fact but stored as text in the table.How can I do with this strange situation. I'v

Solution 1:

you could always cast the text to an int:

SELECT MAX(CAST(ColunmName) as int) from TABLE