Yes and no. Full-text indexing does provide the functionality that you're looking for but your query is wrong. Full-text indexing requires that you query use CONTAINS, CONTAINSTABLE, FREETEXT, orFREETEXTTABLE.
Also, Full-Text indexes are NOT dynamically maintained. You will have to schedule a job to update them.
-Mike
>Assuming a table is properly defined to benefit of the full text indexing, does this mean that we just simply to continue to use queries like:
>
>
>select * from News where NotesA LIKE '%DATA%'
>
>
>which will continue to work but the process time will be immediate as oppose to not having set the table to benefit of full text indexing?
>
>Basically, from the query side, having or not a table to be optimized for that, would the way to query remain the same?