sql 2005 type of field

Hi

I am using SQL server 2005 and I want to create a table that has 2 fields,one field of type integer but the other field i don't know which type to assign to it.

Let me explain I want to store a paragraph that has bullets into this field and using a RichTextBox I want to display the field with exactly the same formatting in my form

example:I want to save the following text with the same formatting to the field
Soft drinks

• Orange
• Lemon
• water

Which type of field should I use?

thanks

varchar

Agreed, and what you save to it should be the RTFText (or similar name) property of the RichTextBox, which contains the text and formatting in a textual form.

Depending on what you're using the rich text box for it can be worth saving the .text property as well as the richtext property. Strictly speaking it breaks third normal form but it makes life alot easier when you come to do comparisons in sql statements.