sqlite convert to int code example
Example: convert varchar to int in sqlite
CAST(myStringNum as REAL)
CAST(myStringNum as INT)
CAST(myStringNum as DOUBLE)
CAST(myStringNum as REAL)
CAST(myStringNum as INT)
CAST(myStringNum as DOUBLE)