Reported By: Marilyn Fleming Reported On: 10/27/1999 For: Version 1.18 Build 1
# 496Using Upper() in a Query WHERE Clause Condition or Join Causes Incorrect Result Set I put a secondary index (case insensitive) on SpecID and tried again. It runs instantly. It also returns only one record (it should be about 100). I took out 'upper' on the join and got all the records in about 30 sec. Is there some way to make the join case-insensitve?
CommentsWhen using the Upper() SQL function in joins or WHERE clause conditions with available case-insensitive indexes to optimize the condition, incorrect results would be returned due to the Upper() function not handling non-Machine ASCII upper-casing properly.
ResolutionFixed Problem on 10/28/1999 in version 1.19 build 1