troubleshooting Question

sql query

Avatar of JCWEBHOST
JCWEBHOST asked on
ASP.NETMicrosoft SQL Server 2008SQL
20 Comments1 Solution338 ViewsLast Modified:
Hey guys, i have a database and a coloum called foodtypes which stores all my food types for a restaurant.

hey is a sample layout

id        Restaurant_Name     Food_Types        
1         ritz                             Buffet,Chinese,Indian


now in my website i have a checklistbox which the user select the food types :
here is a list of my checkboxlist

Buffet
Chinese
Indian
Italian
Portuguese
Seafood
Other

now if the user selects one of the following i want to do a search?

the hard part is that my coloum where my foodtypes is stored for a reastarant has "," to seperate the food types :( .

please help?

how would i go about to search in a query?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 20 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros