"ChuSoft" <cc3412@legalxtranet.com> wrote in message
news:uFWSwoL8HHA.3716@TK2MSFTNGP03.phx.gbl...
> We need to index and search on "(specific text here)".
>
> How can we do a free text search using the above.
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:uf8n$2T8HHA.1204@TK2MSFTNGP03.phx.gbl...
> full text index your table on the columns you wish to search and then do
> this
>
> select * from tablename where freetext(*,'"(specific text here)")
>
>
> --
> 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
> "ChuSoft" <cc3412@legalxtranet.com> wrote in message
> news:uFWSwoL8HHA.3716@TK2MSFTNGP03.phx.gbl...
>> We need to index and search on "(specific text here)".
>>
>> How can we do a free text search using the above.
>>
>
>

"ChuSoft" <cc3412@legalxtranet.com> wrote in message
news:OzVbyxa8HHA.4736@TK2MSFTNGP06.phx.gbl...
> Try it and it returns rows that does NOT have the "(some text here)".
>
> It all rows that have "some text here"
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:uf8n$2T8HHA.1204@TK2MSFTNGP03.phx.gbl...
>> full text index your table on the columns you wish to search and then do
>> this
>>
>> select * from tablename where freetext(*,'"(specific text here)")
>>
>>
>> --
>> 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
>> "ChuSoft" <cc3412@legalxtranet.com> wrote in message
>> news:uFWSwoL8HHA.3716@TK2MSFTNGP03.phx.gbl...
>>> We need to index and search on "(specific text here)".
>>>
>>> How can we do a free text search using the above.
>>>
>>
>>
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:O2yAoNb8HHA.1208@TK2MSFTNGP03.phx.gbl...
>I am sorry I misunderstood you question. Basically the brackets are not
>indexed and are ignored in searches.
>
> --
> 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
> "ChuSoft" <cc3412@legalxtranet.com> wrote in message
> news:OzVbyxa8HHA.4736@TK2MSFTNGP06.phx.gbl...
>> Try it and it returns rows that does NOT have the "(some text here)".
>>
>> It all rows that have "some text here"
>>
>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
>> news:uf8n$2T8HHA.1204@TK2MSFTNGP03.phx.gbl...
>>> full text index your table on the columns you wish to search and then do
>>> this
>>>
>>> select * from tablename where freetext(*,'"(specific text here)")
>>>
>>>
>>> --
>>> 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
>>> "ChuSoft" <cc3412@legalxtranet.com> wrote in message
>>> news:uFWSwoL8HHA.3716@TK2MSFTNGP03.phx.gbl...
>>>> We need to index and search on "(specific text here)".
>>>>
>>>> How can we do a free text search using the above.
>>>>
>>>
>>>
>>
>>
>
>

"ChuSoft" <cc3412@legalxtranet.com> wrote in message
news:ebqnBN88HHA.5404@TK2MSFTNGP02.phx.gbl...
> Is there anyway to index and search on the phrase with brackets?
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:O2yAoNb8HHA.1208@TK2MSFTNGP03.phx.gbl...
>>I am sorry I misunderstood you question. Basically the brackets are not
>>indexed and are ignored in searches.
>>
>> --
>> 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
>> "ChuSoft" <cc3412@legalxtranet.com> wrote in message
>> news:OzVbyxa8HHA.4736@TK2MSFTNGP06.phx.gbl...
>>> Try it and it returns rows that does NOT have the "(some text here)".
>>>
>>> It all rows that have "some text here"
>>>
>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
>>> news:uf8n$2T8HHA.1204@TK2MSFTNGP03.phx.gbl...
>>>> full text index your table on the columns you wish to search and then
>>>> do this
>>>>
>>>> select * from tablename where freetext(*,'"(specific text here)")
>>>>
>>>>
>>>> --
>>>> 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
>>>> "ChuSoft" <cc3412@legalxtranet.com> wrote in message
>>>> news:uFWSwoL8HHA.3716@TK2MSFTNGP03.phx.gbl...
>>>>> We need to index and search on "(specific text here)".
>>>>>
>>>>> How can we do a free text search using the above.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>