Reported By: Yavuz Özdemir Reported On: 2/27/2002 For: Version 3.06 Build 1
# 1040SQL and Filter LENGTH Function Returning Incorrect Results I meet an error for length function on DBISAM 3.06 for Delphi 5. If I omit the where clause everything is OK; but sql with where clause retrive empty set for every constant. See the following SQL:
select item,length(item) from dic
where
length(item)>20
ResolutionFixed Problem on 2/27/2002 in version 3.07 build 1