Icon View Incident Report

Serious Serious
Reported By: Dave M
Reported On: 3/10/2007
For: Version 1.01 Build 1
# 2267 LIKE Operator with No % Wildcards Causes No Rows to be Found

SQL operator LIKE can not return exact match or single character wildcard without %.

SELECT * from sometable
WHERE lastname = 'Jones'

SELECT * from sometable
WHERE lastname = 'J_nes'



Resolution Resolution
Fixed Problem on 3/11/2007 in version 1.02 build 1


Products Affected Products Affected
ElevateDB 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

Image