<kforem@hotmail.co.uk> wrote in message
news:1151483904.783255.323560@p79g2000cwp.googlegroups.com...
>
> kforem@hotmail.co.uk wrote:
>> Hello,
>>
>> I have a fulltext indexed column which contains some like:
>>
>> Section 0 Name
>> Section 1 Name
>>
>> When I run a query like:
>>
>> select *
>> from tbl_FullTextData
>> where contains(name,'"section 0"')
>>
>> It returns records, but when I run:
>>
>> select *
>> from tbl_Schemenamesearch
>> where contains(name,'"section 0*"')
>>
>> It does not return anything. Not sure why this is happening.
>
>
> Have found the answer:
>
> Need to put a space after the wildcard e.g.:
>
> select *
> from tbl_Schemenamesearch
> where contains(name,'"section 0* "')
>

kforem@hotmail.co.uk wrote:
> Hello,
>
> I have a fulltext indexed column which contains some like:
>
> Section 0 Name
> Section 1 Name
>
> When I run a query like:
>
> select *
> from tbl_FullTextData
> where contains(name,'"section 0"')
>
> It returns records, but when I run:
>
> select *
> from tbl_Schemenamesearch
> where contains(name,'"section 0*"')
>
> It does not return anything. Not sure why this is happening.