Re: ActualSize returns -1 for Text fields

Mark

> If you know that max size of the field's content will stay under 8060 -
> [size of other fields] and/or truncation is tolerable, and you only need
> read-only access to it, you can convert it to varchar in the SQL
statement:
>
> SELECT CONVERT(varchar(6000), [MyTextCol1]) As MyTextCol1 FROM ...

Thanks for the suggestion but unfortunatly neither of those criteria holds
for my situation. My table has multiple Text fields, anyone of which is
typically larger than the 8060 limit (which is the reason I am using Text
CLOB fields in the first place) and I need read/write access to them as
well.

What I need here is a fix from MS.

Rod


.