Size in KB

[Dave Karmens]

I have two NTEXT fields that hold HTML data -- is there a way I could
display the size of the values in the fields in KB?

[Aaron Bertrand - MVP]

Why are they NTEXT? Are you requiring support for foreign alphabets?

Anyway you might have to divide this by 2 depending on whether you are
interested in eventual byte count or storage byte count.

SELECT DATALENGTH(column)/1024.00 FROM tablename

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Dave Karmens" <spam_just1coder@yahoo.ca> wrote in message
news:eT6blsx9DHA.3436@tk2msftngp13.phx.gbl...

> I have two NTEXT fields that hold HTML data -- is there a way I could
> display the size of the values in the fields in KB?

[Dave Karmens]

Aaron Bertrand - MVP wrote:

> Why are they NTEXT? Are you requiring support for foreign alphabets?

Yes.

> Anyway you might have to divide this by 2 depending on whether you are
> interested in eventual byte count or storage byte count.
>
> SELECT DATALENGTH(column)/1024.00 FROM tablename

Ah. Thanks. That will work nicely.