I was wondering if anyone how to handle this coulmn can I create indexes or better can text column support full text indexing.
Anyone who can shed any ideas as what might be the best possible solution will be great
AdAnup
If I understand you correctly, YES, Full Text indexing is especially well suited for fields with text/ntext datatypes.
Be aware that Full Text indexing is not dynamic, that is, the indexes will not be updated to reflect any inserts/updates/deletes to the data -UNTIL you specifically rebuild the Full Text indexes. You may wish to create a scheduled SQL Agent Job to rebuild the Full Text indexes during 'slack' times.
Read in Books Online about Full Text Indexing.
