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

Disregard my previous message, It should have been posted in ElevateDB, not DBISAM.

Dave M