Hello all,

I was wondering how to get the data from a column when the column has a space. The column name is 'currency -'. Unfortunately I cannot get the data of this column. I already used single and double spaces, but that is also not the solution. Maybe somebody can help? Thanks.

Put the column name in double quote.

SELECT "currency -" FROM your-table


keep in mind, that the column-name is case sensitiv if you use double quotes.

SELECT "currency -" FROM your-table

is not the same as

SELECT "Currency -" FROM your-table

If you want to select "the data from a column when the column has a space",
use:
WHERE "currency -" LIKE '% %'
or
SELECT CASE WHEN "currency -" LIKE '% %' THEN "currency -" ELSE ... END

and note what umayer said: