Full text-syn - 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)

Full text-syn

Author

Topic

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2002-12-31 : 08:07:40

Hi,

I have setup full text search on item master table(which has primary key on item number).
using the below qry

Select Item_Number from Item_Master
Where contains(Item_Number,'"ACC-0200WN"')

to search for a specific item.
The search does not produce any output even tho' the item is present,wht could be reason for this?
Thanx

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-12-31 : 09:52:59

Is Item_Number = "ACC-0200WN" OR "*ACC-0200WN*"?
If it's the second then you need

Select Item_Number from Item_Master
Where contains(Item_Number,' "ACC-0200WN" ')

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2003-01-02 : 02:05:09

The item number has a perfect match in table
as-
Item_Number = "ACC-0200WN"

If tried with normal qry like
Select Item_Number from Item_Master
Where Item_Number='ACC-0200WN'

it gives results

What could be the solution for this??

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-01-02 : 02:58:56

What version of sql server and what service pack?

Can you provide some ddl for testing.

This works in Northwind using sql 2k sp2
first run full indexing option on categories table then
start full population


SELECT * FROM CATEGORIES
WHERE CONTAINS(CategoryName,'"Beverages"')

SELECT * FROM CATEGORIES
WHERE CategoryName Like 'Beverages'

Edited by - ValterBorges on 01/02/2003 03:17:05

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2003-01-03 : 05:27:59

Hi,
I reinstalled sql server on the developement server, the full text search is working fine.

thanx valter.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources