Search Engine

alter table T_FILES add constraint un_t_filedata unique(file_sysid)

EXEC sp_fulltext_database  'enable'

--1  Create the catalog (unless you already have)

EXEC sp_fulltext_catalog   'FTCatalog','create'

--2  Add a full text index to a table

EXEC sp_fulltext_table  'T_FILES', 'create', 'FTCatalog', 'un_t_filedata'

--3  Add a column to the full text index

EXEC sp_fulltext_column    'T_FILES', 'FILE_DATA', 'add'

EXEC sp_fulltext_column    'T_FILES', 'FILE_EXTENSION', 'add'

EXEC sp_fulltext_column  'T_FILES','FILE_DATA','ADD',2057,'FILE_EXTENSION'

EXEC sp_fulltext_table     'T_FILES','activate'

--5  Start full population

EXEC sp_fulltext_catalog   'FTCatalog', 'start_full'

--select document_type, path from sys.fulltext_document_types

exec sp_fulltext_service 'load_os_resources', 1;

exec sp_fulltext_service 'verify_signature', 0;

after complete the above steps write sql query as

select * from T_FILES  WHERE FREETEXT(FILE_DATA,'Beware of duplicate')

here T_FILES is table

file_data,file_extension are table column names