convert string to int in sqlite db 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)