Column names with "space"


#1

Hi Team,

My columns have space in the column names, could you let me know, how to use those columns as filters?
Like for example column name is [product category]. I am unable to use the filter statement as in

SELECT * FROM PRODUCTS
WHERE TRUE
[[AND [product category] = {{ [product category]}}]]
The above query does not work as filter , neither it gives and option to specify what type of data it holds. Could you advise?


#2

3 points:

  1. It’s easier to just define it as a field filter rather than putting the whole WHERE clause in.
  2. If you do want to do it like this, try using double quotes around the column name rather than the square brackets.
  3. Find your database designer and explain why spaces in column names are a really stupid idea.