rob — 2005-02-02T17:15:31-05:00 — #1
Many thank you's in advance.
asterix — 2005-02-03T07:43:30-05:00 — #2
To find the length of a field
select Len(field) from table
the 4 MB limit is more likely coming from ADO than from mssql, qhich can store up to 2 GB in one of these fields
asterix — 2005-02-03T07:45:59-05:00 — #3
Oh, I see, you want to know the length of the data, not the field size...
select datalength(field) from table
where PK = Expression
rob — 2005-02-03T11:54:21-05:00 — #4
Fan(blooming)tastic! I could not find that datalength documented anywhere. Now I know the name of the function I can read up on it in SQL Server Books Online.
Thank you very very very very very very very much. This is going to save me a lot of headache in dealing with our SQL CDBA's.
mittineague — 2014-09-24T01:55:52-04:00 — #5
This topic is now archived. It is frozen and cannot be changed in any way.