Convert integer to text in SQLite's SELECT query? Convert integer to text in SQLite's SELECT query? sqlite sqlite

Convert integer to text in SQLite's SELECT query?


SQLite supports CAST and:

Casting an INTEGER or REAL value into TEXT renders the value as if via sqlite3_snprintf() except that the resulting TEXT uses the encoding of the database connection.

So you can do things like this:

select cast(some_integer_column as text) from some_table;

Or, depending on what you're trying to do, you could just treat the numbers as strings and let SQLite coerce the types as it sees fit:

select some_int || ' pancakes' from some_table;select some_int || '' from some_table;