text data type and keyword search

[redapple]

Hello, I am new to SQL server.
We are going to create a website which is basically for articles searching . Since most of them are very long, over 30 pages at least, probably only data type "text" is capable of storing them (please correct me if I am wrong). As far as I know there are some limitations of text data type.

Question is: can I do a keyword search in a "text" field? Is there any other limitations to text data type, which will make search difficult?

Thank you.

 

[PFR]

no

You just cannot compare the whole string with "=" or apply any string-based function within a query but such operations seem nonsense for 30 paged documents

Search the table(s) using "LIKE" or build fulltext indices on them and use "CONTAINS" etc.

PFR