sql server full text search: double space handling -- sql server full text search

double space handling

Sudhir
9/4/2007 5:22:03 AM

sql server full text search: HI,

I am having a problem with double space handler.

i'm taking user input to search for any description, but the problem is that
when user enters search criterion with double spaces in that. for eg 'rock
music' is ok, but if user enters for 'rock music' that means double spacing
between these two words that serach takes 'and' operator and that gives the
error on query.

Re: double space handling

Hilary Cotter
9/4/2007 10:09:20 AM

can you try a tsql replace, ie

declare @string varchar(100)
set @string='Rock Music'
select @string=replace(@string,' ',' ')

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]