Query help - OR operator

DaweUrbi

Hello, I would like to ask for small help about my query.

SELECT H, F, G, C, D, E, W WHERE I = “-”

Currently, I am able to export my columns if in column I is -. But I would like more conditions there and operator OR doesn’t work as I expected from SQL. I tried many options with parentheses but without success, bellow you can find the query what I would like to have.

SELECT H, F, G, C, D, E, W WHERE I = “-” OR “x” OR “X”

Thanks for help

Dieferson

The WHERE clause can be combined with AND, OR, and NOT operators.
The AND and OR operators are used to filter records based on more than one condition:

The AND operator displays a record if all the conditions separated by AND are TRUE.
The OR operator displays a record if any of the conditions separated by OR is TRUE.

Please, could you try this: WHERE I = “-” OR I = “x” OR I = “X”

DaweUrbi

Thank you for hint! Your query works I just had to change a bit from double quotes to single quotes.