Using query builder the IN clause is parsing incorrectly. Version 5.2.0.276 (as well as 5.1.6.206) 32 bit. After checking the check boxes and clicking ok the IN clause is parsed as IN( '2019','2020', 'Fall','Fall') instead of IN('Fall 2019', 'Fall 2020') Thanks
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Toad Data Point 5.7 IN statement incorrectly parses names | 5 | 568 | June 1, 2022 | |
Formatting on IN clause strings | 2 | 700 | October 2, 2020 | |
Query builder - generates invalid syntax WHERE x IN (a,b,c) | 0 | 653 | October 24, 2014 | |
HELP - Can someone review this query and tell me where my SQL is wrong? | 9 | 560 | July 13, 2011 | |
Want to use Visual Query Builder and "In Clause" Variables? | 2 | 715 | November 17, 2021 |