Sorry for accidentally posting twice (once in DBISAM general).

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

Sql below returns no results for Jones:
--------------------------------------------
SELECT * from sometable
WHERE lastname = 'Jones'

SELECT * from sometable
WHERE lastname = 'J_nes'


This SQL returns Jones (plus records such as Jones/Smith):
-------------------------------------------------------------------
SELECT * from sometable
WHERE lastname = 'Jones%'

SELECT * from sometable
WHERE lastname = 'J_nes%'

Dave M

Dave,

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

Got it.  The workaround is to use the equals operator instead for now.

--
Tim Young
Elevate Software
www.elevatesoft.com