Multiple Filtering on the same field using a Stored Procedure

Hello,

I am looking at writing a SP without much success which enables multiple filtering on one field. Something like below:

Input field: Product Description

So if the user enters: "Large Drill" OR "Drill Large" the same resultset will be returned.

SELECT * FROM products WHERE products.prod_desc contains both "Large" AND "Drill"

I guess there'll need to be a nested Select and loop to parse the space separated input field.

Any pointers would be appreciated.

Thank you

Lee

hi dear,

I answer the same question on MSDN forum....you can reach this via this link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1448983&SiteID=1

Thank You

Best Regards,

Muhammad Akhtar Shiekh

|||

Thank you very much Muhammad

Problem solved.