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...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)