Searching for words using like command
Guys im having this problem im using the commandheadline like '%"+TextBox+"%'This command works but I want to search for individual words inputted in the TextBox, can anybody help me... Thanks
Sorry, may have misunderstood your question.You can only use sql to return a record, not a single word from text in a record.If you need to find a word within a string you will have to use java code to search that string for the word.