<div>
use datalength() function:<br />
<br />
SELECT propertyID <br />
FROM properties <br />
WHERE DATALENGTH(propertyDescrip<wbr />tion) &gt;&nbsp;200<br />
<br />
CHeers<br />

</div>


use datalength() function:

SELECT propertyID
FROM properties
WHERE DATALENGTH(propertyDescription) > 200

CHeers


<div>
Great!<br />
<br />
angelIII I think I'm going to split the point on this one between you two as if Rimvis hadn't suggested his comment I'd have been sratching my head for ages!!!!<br />
<br />
No problem I hope?<br />
<br />

</div>


Great!

angelIII I think I'm going to split the point on this one between you two as if Rimvis hadn't suggested his comment I'd have been sratching my head for ages!!!!

No problem I hope?



<div>
Give all the points to Rimvis, his answer was complete!<br />
CHeers
</div>


Give all the points to Rimvis, his answer was complete!
CHeers

<div>
That very noble of you angelIII I'll sort you out next time.<br />
<br />
Ben
</div>


That very noble of you angelIII I'll sort you out next time.

Ben

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
SELECT propertyID FROM properties WHERE LEN(propertyDescription) &gt;&nbsp;200<br />
<br />
gives me the result<br />
<br />
Server: Msg 8116, Level 16, State 2, Line 1<br />
Argument data type ntext is invalid for argument 1 of len function.<br />
<br />
So maybe I can't len ntext fields?<br />
<br />
Any one know of a work around?<br />
<br />
Ben
</div>
</div>


Hi,

SELECT propertyID FROM properties WHERE LEN(propertyDescription) > 200

gives me the result

Server: Msg 8116, Level 16, State 2, Line 1
Argument data type ntext is invalid for argument 1 of len function.

So maybe I can't len ntext fields?

Any one know of a work around?

Ben

Getting LEN of field type ntext

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.