<p>How do you find out the length/size of the data in an ntext column in SQL? - It's longer than 8000 bytes so I can't cast it to a varchar. Thanks.</p>

Use
DataLength()
```
```
SELECT * FROM YourTable WHERE DataLength(NTextFieldName) > 0
```
```