CONTAINS in Full Text Searching

Hi

I've used CONTAINS on a varchar field.

in SQL SERVER 2000

the query was "Select name from description where CONTAINS(name,' "donot*" ')

say if I search for "Select name from description where CONTAINS(name,' "donot a*" ')

it doesn't return rows.

as might be it is seeing that 'a' as the starting letter of AND key word which is used in CONTAINS

but how to tell that it is my next letter in the search

Really I need more clarity on this...

Thanxs in advance

Could you explain what results you would expect to achieve from both queries?

Also, can you confirm that you are running both queries on SQL2k?

|||

And is only recognized by SQL Server if you specify it as a whole word (AND). A* Assumes a word with the first letter A.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

I'm using SQL Server 2000

say my list consists of "donot alter" word...I'm not getting that row in my output.

|||Which wordbreaker are you using ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

I just used this query

Select name from description where CONTAINS(name,' "donot a*" ')

on the description table with full-text searching on Name field.