i need to search records based on the given keyword,whatever keyword matches in the database among the tables.
whereas i'd implement fulltext search option as follows
enabled full text search using query.
create index in table field.
created catalog for all tables.
created population among the tables
but if i use the query, no result is showing
select * from Fileupload where CONTAINS(Name,'kumar')
Select * from Fileupload where FREETEXT(*,'kumar')
i'd use above queries no result is displaying, but Fileupload table contains record with word kumar
please give me the solution