Because data is imported as string, I need to query string values as if they were integers, is there something I could use to cast values to string?
Where could I find documentation for this SQL in CartoDB? I found this
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
There are two ways. Screencap below
Just recast it as a number using the user interface, you can find the option right under the column name.
Select it dynamically with SQL, but there are only few cases where this makes sense.
select *, field::int xx from my_table where field::int=1
You can't use column alias in a WHERE clause. see this answer on stackoverflow