I don't know, but I had such an error also, if I deleted the - it was ok. 
(R08-45 and B08-15)

I don't know, but when I had such a error it solved my problem.

GreetZ

Wesley
www.web-art.be


>From: stephen.trigg@p...
>Reply-To: "sql language" <sql_language@p...>
>To: "sql language" <sql_language@p...>
>Subject: [sql_language] Re: Simple SQL question
>Date: Tue, 2 Apr 2002 15:57:58
>
>The syntax is fine Barb, nothing wrong with the statement.
>
>Do you have any more details, like how are you executing the sql statement,
>through ADO? Stored Procdure? Query in Access? What is the table schema?
>
>Stephen
>
>A couple of things to try check
> > Hi,
>
> > I am a 'newbie'....I have a simple question.
>
> > I have a 'routes' table that contains many route Names. The customer
>w> ants to be able to fill in a form and type in many route name's (from 1
>t> o 20 different routes depending on an ever changing situation).
>
> > I want to be able to produce a list of routes that meet all their
>criteria
>s> o I'm just using a select statement similar to this (in this case the
>c> ustomer only wants two routes R08-45 and Route B08-15):
>
> > SELECT * FROM [Routes] WHERE Route_Name = 'R08-45' OR Route_Name = 'B08-
>1> 5' ORDER BY [Route_Name]DESC
>
> >
>I>  get a Syntax error (missing operator) in query expression.
>
> > Can I not specify two different criteria of Route_Name? or what is wrong
>w> ith my syntax?  Route_Name is not the key field.
>
> > help!?
>
> > Barb




_________________________________________________________________
Download MSN Explorer gratis van http://explorer.msn.nl/intl.asp.