suppose i want to store text into a table. what is the best data type? on average, the text would be about one or two paragraphs long. for now i am just using varchar until i can find something better....could anyone tell me about blob?

Hi, you can use nvarchar data type. If your text has thousands of characters then use Text Data type.

Madhivanan