convert varchar to int in sqlite
snippet in sql

convert varchar to int in sqlite

user2130

CAST(myStringNum as REAL)
CAST(myStringNum as INT)
CAST(myStringNum as DOUBLE)