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
[215 byte] By [Vincent_pogia] at [2007-10-3 0:33:52]
# 1
Do NOT use the wildcards "%" http://www.w3schools.com/sql/sql_where.asp
angrycata at 2007-7-14 17:27:28 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
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.
angrycata at 2007-7-14 17:27:28 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...