🚀 go-pugleaf

try the following syntax:

.......   WHERE  fieldname LIKE   '%Mark%'

The LIKE that you have in your example is the DBase LIKE(), and it
won't work in SQL.

Rob K.




On Thu, 01 Jan 1998 23:45:28 GMT, tim@nurse.demon.co.uk (Tim Harrison)
wrote:

>Forgive me if this question seems a bit simple, but I'm new to this SQL lark.
>I'm trying to select a number of records which *contain* a certain letter in a
>field. (I have a generic "MARKERS" field set up which I use to mark records I
>want to delete, follow up etc) In vDbase 5.6 an example query condition was
>	"B" $ Table->Markers
>Can anyone suggest a corresponding SQL statement? More specifically, what's
>wrong with the statement I'm trying to use (below) in an SQL file to select
>records? This generates an "invalid use of keyword" error message.
>
>SELECT *
>FROM "C:\program files\Visual dBase\testagil\members.dbf" Members
>   FULL OUTER JOIN "C:\program files\Visual dBase\testagil\club_dog.dbf"
>Club_dog
>   ON  (Members.MEMBER_ID = Club_dog.HAND_ID)  
>WHERE LIKE("*B*",Members.Mark)
>
>Thanks in advance for your help.
>Tim