Reported By: Manfred Wekwerth Reported On: 11/9/2000 For: Version 2.04 Build 1
# 655Executing a Filter or SQL Where Condition with >= and <= Range Comparisons Doesn't Work Properly Executing an optimized filter or SQL statement with a where condition that contains >= and <= comparisons on the same value results in the value not being found, even when it exists. This occurs with the German language driver, but not with the ANSI Standard language driver. If the optimized filter or SQL statement's where condition uses the = operator, the query or filter returns the correct results.
{ This query does not return any records }
SELECT * FROM country WHERE Name >= 'Zurich' AND Name <= 'Zurich'
{ This query works properly }
SELECT * FROM country WHERE Name = 'Zurich'
ResolutionFixed Problem on 11/12/2000 in version 2.05 build 1