Member Avatar for H4voc

OK, this may not be possible in SQL, but here goes.

I'm writing an app that allows the end user to select a date range and filter by area code, but I want them to be able to select as many area codes as they want. My question is with the "WHERE" clause.
Is there a way to do an "implied" OR for instance:

where areacode=405|913|665

Normally i would just do:

where areacode = 405 or areacode = 913 or areacode =665

But in this case i would be easier to use the first option.

Hope this makes sense!

  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by apegram
Member Avatar for apegram

In.

Where areacode In (405,913,665)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.