Click here to Skip to main content
15,922,523 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello,
       I am Planning to write an storedProcedure for search criteria. In that sp I want to give an input parameter.... which will be like this


        @ItemSearch varchar(256)
        @ItemSearch ='2013*freedom*Kit'

If you observe the input value... The '*' in it is a separation between key word... now I want to search data having key word 2013 at first.... Then in that filtered data I ant to search with second key word 'freedom' and from that filtered records again it will filter with freedom key word... Now again if the third key word exists then it should again get filtered....In item Search the key words are not fixed.... they may vary 

Please... get me the solution if you have any way to achieve my requirement...
Posted
Updated 9-Dec-13 1:25am
v2

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900