Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Apr 21, 1997

WHERE (multiple values)

Question:
I have a form in which the user can select multiple values of "Manufacturer" from a drop-down list.

The query should then select from the database all records in which Manufacturer matches one of those listed. It works fine when a single manufacturer is selected, but what syntax do I use to match multiple Manufacturers?

Answer:
Using the IN predicate in your WHERE clause will match the records:

...WHERE manufacturer IN (selection_list);
The exact syntax will depend on your database product -- you may be able to specify variable names to make the statement more portable. Check your documentation for the details.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date