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!

how to search/check individual words within cell...

Status
Not open for further replies.

spewn

Programmer
May 7, 2001
1,034

suppose i wanted to perform a search for different widgets in my database. i am looking for any widgets with the color green in them. however, some widgets have multiple colors, and under my 'color' column of the widget DB i have 1 widget that is "blue, green, red" for color description.

my question is how to perform a search and still include the 1 multi-colored widget, even though my search parameter is "green", not "blue, green red"??

any ideas?

- g
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top