Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 full text search-error

Author  Topic 

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2001-09-26 : 23:54:20
Sir,
I am trying query on table 'detail', which is full text indexed. while searching for a single character it gives error!!!.

Select * from Detail where contains(*,'"a"')

Error Message from sqlserver:

The query contained only ignored words.[red]


II) while searching for word like "networking
products", does it search out individual
words(networking or products), if so how can it be made as one word
for search using contains or some other function(freetext)?????
Thank you.



   

- Advertisement -