Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ntext datatype

Status
Not open for further replies.
shultz

shultz

Programmer
Joined
Oct 28, 2001
Messages
42
Location
HK
How can I get the length of a value stored in a field which of type "ntext".

Because If I give

select len(csrDescription) from tblImport

the query analyzer gives me an error message. If there any other way round to find the length of the string.
 
Sort by date Sort by votes
Try:

select datalength(csrDescription) from tblImport

Rick.


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gussy81
  • Locked
  • Question Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller
sanmikele2
  • Locked
  • Question Question
Creating a table and limiting datatype entry
Replies
6
Views
393
Olaf Doschke
Olaf Doschke
alexjones
  • Locked
  • Question Question
SQL Server datatype "best" for use in creating XML file
Replies
1
Views
215
TonHu
TonHu
1DMF
  • Locked
  • Question Question
SELECT UNION - nText Field?
Replies
7
Views
296
1DMF
1DMF
JustATheory
  • Locked
  • Question Question
Timestamp DataType
Replies
2
Views
187
TheBugSlayer
TheBugSlayer

Part and Inventory Search

Sponsor

Back
Top