Reported By: Elevate Software Reported On: 7/6/2000 For: Version 2.03 Build 1
# 590SQL SELECT IN Operator Failing If Field Name and Search Term Are Identical No records are returned an SQL SELECT query if the field name and the search term for an IN comparison are the same, it works with '=' though.
SELECT * FROM CUSTOMER WHERE Company IN("Company")
ResolutionFixed Problem on 7/7/2000 in version 2.04 build 1