Reported By: Harry de Boer Reported On: 4/23/2007 For: Version 1.02 Build 1
# 2333Leading Wildcard Searches with the LIKE Operator Not Working Properly I have records in table test that ends with 'abc'. I tried the following SQL but the fields that contain the 'abc' at the end are in the result set.
select * from test
where veld2 not like '%abc'
and veld1 < 100
ResolutionFixed Problem on 4/24/2007 in version 1.03 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial