ASP/Access query syntax question

  • Thread starter Thread starter bender
  • Start date Start date
B

bender

I used to know this, but now I've forgotten.

Using the NOT LIKE, if I want to end a query with "...WHERE country
NOT LIKE 'USA' "

what characters do I put around USA to make this work? And isn't
there a good reference page somewhere on the 'net that shows these
syntax things all together for MS SQL and Access, etc.?

thanks

Larry
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."
 
In IE Address bar type:

? ASP SQL Select Query

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
 
In IE Address bar type:

? ASP SQL Select Query
Click to expand...
+++++++++++++++++++++++++++++++++++++++
thanks. the penny finally dropped: i was putting my GROUP BY in front
of the WHERE statement, so nothing was working right. Been a long day.

Larry

- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."
 
Hi Larry,

There are indeed places where the SQL Syntax of various databases can be
found. However, I know of no one place where the syntax for ALL of them can
be found. So, if you'll tell me what database product you're using (via this
NG, not by private emial, please), I'll help you with your query.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
Back
Top