hi all,

How can i enable full text searching (indexing)-- If you might recall ... when windows is newly installed .. and for the first time you go for windows help ... it gives a message Preparing Index for first use.

This type of search is far more faster and accurate than the usual

select * from tablename where fieldname like 'abc%'

Is there any windows component that can be used or any third party product available ?

thanks
Robinson