Using CONTAINS - SQL Server Forums

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

SQL Server Development (2000)

Using CONTAINS

Author

Topic

Nato
Starting Member

30 Posts

Posted - 2003-09-03 : 11:15:21

This query is not working for me:

select ID, Name from Product where CONTAINS (Name, '2')

here is the answer i get:

Execution of a full-text operation failed. A clause of the query contained only ignored words.

Can you not do a CONTAINS and use a number as the search term! Thats would seem strange.

mr_mist
Grunnio

1870 Posts

Posted - 2003-09-04 : 03:21:38

It seems like it has problems with anything that just has only a single character of any kind in the search string. It doesn't seem to link single character + wildcard either.

-------
Moo. :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources