I’m using query builder in TDP 3.6 and I am trying to use the IN operator in the WHERE clause. I am trying to select ‘’ (empty string), ‘QUAL’, ‘UNAV’, etc. but for the empty string it just puts in a comma. When I run the query it returns the error Incorrect syntax near ‘,’.
Is this a bug, or is there some other way to choose an empty string?