Does Fulltext work on text fields?

I thought it didnt, but I just changed my varChar(8000) field to text and it
still seemed to work !

Thanks,

Tom

It works on text, char, nchar, varchar, nvarchar, image (with the document
type column containing the extension the file would have if it was in the
file system and the ifilter is in the os and SQL is configured to load it),
and varbinary(max) (with the document type column containing the extension
the file would have if it was in the file system and the ifilter is in the
os and SQL is configured to load it).

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



[quoted text, click to view]

Yep it does.

[quoted text, click to view]