large VarChar vs Text

Hi,

We are using SQL 2K with SP4.

We have a char field which can potentially have up to 6,400 characters,
should we use Text instead.   Is there a guideline to when we should use Tex
t
vs Varchar?  I am concerning which way will give us the best storage
management and performance.

wingman

If you read Books Online (the reference materials that come with SQL Server)
you will probably come to the conclusion that you should use varchar.

Varchar is much more flexible, and it is easier to work with.

--
Keith Kratochvil


"Wingman" <Wingman@discussions.microsoft.com> wrote in message
news:8EECDAFE-542C-4727-A106- AF96146CE22F@microso
ft.com...
> Hi,
>
> We are using SQL 2K with SP4.
>
> We have a char field which can potentially have up to 6,400 characters,
> should we use Text instead.   Is there a guideline to when we should use
> Text
> vs Varchar?  I am concerning which way will give us the best storage
> management and performance.
>
> wingman