>Hi everybody,
>
>I have a description field which is currently either varchar or char. I would like to use this field for rich text formatting. What should I choose for the type of the field, how can I transfer the existing data and what else should I consider?
>
>Thanks in advance.
varchar(max) is appropriate. All RTF codes are just strings.
And I suggest varchar(max) just to be sure that you'll have enough space to keep that file.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.