Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using || / OR for search...cell contents = red, blue, green...

Status
Not open for further replies.

spewn

Programmer
May 7, 2001
1,034

how do i search the contents of a cell for either blue or green? assuming the cell contains red, blue, green.

ex.

where color like '%green%' OR like '%blue%'

any help?

- g
 
Code:
... WHERE color IN ('green', 'blue') ...

*cLFlaVA
----------------------------
[tt]insert funny quotation here.[/tt]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top