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?|||>--Original Message--
>is there limitation in number of characters for a field?
>.
> hope this is what u r looking for :
The default maximum precision of numeric and decimal data
types is 38. In previous versions of SQL Server, the
default maximum was 28.
When two char, varchar, binary, or varbinary expressions
are concatenated, the length of the resulting expression
is the sum of the lengths of the two source expressions or
8,000 characters, whichever is less.
When two nchar or nvarchar expressions are concatenated,
the length of the resulting expression is the sum of the
lengths of the two source expressions, or 4,000
characters, whichever is less.
this is extracted from the SQL Books Online
rdgs