Have a look in bol for the facilities available.
Full text search works on words and is very efficient and
does a lot more than just search for a word.
Your like statement will always table scan so won't be
useful on large amounts of data. And what if you want to
search several columns.
It seems to me
just fine. Are there
a lot faster than