When accessing a Jet database via ADO using ANSI SQL, *not* Jet SQL:
www.adopenstatic.com/faq/likequeries.asp

If that still doesn't help, can you post a little more information (eg some
sample data, plus what is returned for each different type of query that you
have tried)

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Michael" <mdehnel@w...>
Subject: [access_asp] LIKE or the *


: strPlyrs = "SELECT " & _
:         "People.Number, " & _
: "People.[1_Name], " & _
: "People.[2_Name], " & _
: "People.Pri_Pos, " & _
: "People.Sec_Pos, " & _
: "People.Bats, " & _
: "People.Throws " & _
:    "FROM " & _
:    "People " & _
:    "WHERE " & _
: "(((People.Pri_Pos) Not Like '*Coach')) " & _
:    "ORDER BY " & _
: "People.[2_Name];"
:
: It is either the '*' or the 'Like' (I'm guessing) that is giving me
: grief.  I grab to lists sorted slightly differently from my database.  One
: is of the coaches and one is of the players.  When I first wrote this I
: had both of them in and was getting the "either EOF or BOF" error for the
: coaches version.  So on a hunch I commented the coaches code out.  I got a
: list of the players however the coaches were there too.  I tested both SQL
: statements in access and they work fine.  Its when I try to run them on
: the server that they are not working properly.
:
: Thanks for the HELP

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~