> i should mention this is Sql 2000 on Win2k
>
> "John S." wrote:
>
>> We have a database full of grocery items that we're trying to search.
>> When I search for "*1%*" it seems that the percent sign is ignored
>> and I get back all the rows that match "*1*" (which is A LOT). Is
>> there anyway I can tell full-text search not to discard the percent
>> sign and treat "1%" as a word?
>>

> Hi Simon,
> I also forgot to mention that I need to do this with CONTAINSTABLE.
> "Simon Sabin" wrote:
>
>> Hello John S.,
>>
>> Try LIKE '*1[%]*'
>>
>> This is explained in BOL
>>
>> Simon Sabin
>> SQL Server MVP
>> http://sqlblogcasts.com/blogs/simons
>>> i should mention this is Sql 2000 on Win2k
>>>
>>> "John S." wrote:
>>>
>>>> We have a database full of grocery items that we're trying to
>>>> search. When I search for "*1%*" it seems that the percent sign is
>>>> ignored and I get back all the rows that match "*1*" (which is A
>>>> LOT). Is there anyway I can tell full-text search not to discard
>>>> the percent sign and treat "1%" as a word?
>>>>