I have a textbox where users put in keywords for searchs. My question is how to search for every word. LIke a user puts in (contract monroe jelly) how would i search for each and every word?
WHERE something = 'contract' OR something = 'monroe' OR something = 'jelly'
Split the input using space as the delimeter then loop through the resulting array to query. See the VBScript reference link at lower left for help with split