Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread LIKE operator returns no results without percent wildcard.
Sat, Mar 10 2007 1:08 AMPermanent Link

Dave M
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
Sat, Mar 10 2007 1:47 AMPermanent Link

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

Dave M
Image