field limitation

is there limitation in number of characters for a field?
Hi,
Yes, there are restriction.
Character Strings information:-
char
Fixed-length non-Unicode character data with a maximum length of 8,000
characters.
varchar
Variable-length non-Unicode data with a maximum of 8,000 characters.
text
Variable-length non-Unicode data with a maximum length of 2^31 - 1
(2,147,483,647) characters.
See topic "data types" in SQL Server books online for more details.
Thanks
Hari
MCDBA
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:EA967BEE-D85D-42B3-B0EB-CD6498B37189@.microsoft.com...
> is there limitation in number of characters for a field?