sqlite cast to integer code example

Example: convert varchar to int in sqlite

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