Issue about full-text index

Hi: all,

I have created a full text index on a column(column1) in a table(table1).

There is one record in the table1. And for example, the column1 stores "Documents".

Table1.Column1:"Documents"

When I run the query:

select * from Table1 where contains(Column1,'Documents')

There is 1 one row be selected.

But when I run the query:

select * from Table1 where contains(Column1,'cum')

There is no row be selected.

So the contains can only search the whole word,right?

Can I search a part of the whole word?

Just like the result of : select * from Table1 where Column1 like '%cum%'?

Thanks,

Tracy

You can search the part of the word but only with Prefixed wild card...

select * from Table1 where contains(Column1,'"Doc*"')|||

So sql server full-text index doesn't support to search any part of a word, right?