Field Lenght Limitation in SQL 7 varchar field type
How do you know the column is not storing all the data?
SELECT MAX(datalength(YourColumnGoesHere)) FROM YourTableGoesHere
How are you inserting data?
stored procedures -- is the input param the right size?
insert statements -- are they correct?
Can you insert correct data via Query Analyzer?
--
Keith, SQL Server MVP
==============
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
Quote:
> I have a field in one of my tables that is to store
> comments. I set the column as varchar(2000), but somehow
> some comments that i'm storing which is 1500 characters
> length won't stick...please help
