>Is it possible to have a SQL Server table with a text search index on a text field?
>
>I would like to allow users to enter keywords and search the entire contents of the text field for an occurrence of the keywords. Is this something native in SQL Server or would this required a third party add-on?
>
>We have been using Visual Foxpro table and a third part add-on called PHDbase to create text search indexes on VFP text fields. But now we would like to have this ability in SQL Server. Is this possible?


A full text index would work. Your going to do

Select myFields
from ThatTable
where FREETEXT (YourColumn, 'YourValue' )

You can do near and weights with it also. It's a good deal like PHDbase as I remember working with it back in the 90's.

Look for the Contains () as well in your searching for getting the near as I remember.