Reported By: Clive Bennett Reported On: 6/4/2004 For: Version 4.07 Build 1
# 1749SQL and Filter NOT IN Operator Not Working Properly The following query does not return any rows.
select * from rpt_generic_detail
where scenario_code = 64 and
rowid not in (84,85)
Workaround:
select * from rpt_generic_detail
where scenario_code = 64 and
rowid <> 84 and rowid <> 85
ResolutionFixed Problem on 6/5/2004 in version 4.08 build 1