Full text query woes - 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

Transact-SQL (2000)

Full text query woes

Author

Topic

ashok
Yak Posting Veteran

57 Posts

Posted - 2003-02-18 : 06:16:27

I have a table that contains a full text indexed column.
I run queries on this table using the contains(*,'word') syntax.
The problem occurs when the column has text with brackets "()" within it, like the following :

Quartier Latin Band (Dance orchestra)

this query does not return anything :


select * from Citations 
where contains(*, '"Quartier Latin Band (Dance orchestra)" ')

so i tried to escape the brackets using a [] like :


select * from Citations 
where contains(*, '"Quartier Latin Band [(]Dance orchestra[)]" ')

But, to no avail.

Is there any other way of escaping the "()" characters properly, short of replacing them full text friendly characters ?

(Yeah, i tried the ESCAPE syntax, but that does not work with FT queries)

thanks
ashok

-ashok
"Bad dancing does not break an engagement."

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-02-18 : 07:33:57

What do you get when you have no brackets at all ?

 
select * from Citations 
where contains(*, '"Quartier Latin Band Dance orchestra"')

HTH
Jasper Smith

ashok
Yak Posting Veteran

57 Posts

Posted - 2003-02-18 : 07:54:30

Nope, even that doesn't work

quote:

What do you get when you have no brackets at all ?

-ashok
"Bad dancing does not break an engagement."

mcp111
Starting Member

44 Posts

Posted - 2004-08-20 : 10:19:34

Have you tried

select * from Citations where contains(*, '"*Quartier*"')

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources