how do I select len(foo) for an ntext field?

From: marty (marty_at_discussions.microsoft.com)
Date: 05/04/04 

Date: Tue, 4 May 2004 15:22:01 -0700

I want to do a select on a field and get the data lengths in the field but sql tells me I can't because it is ntext. 

-- 
thanks
marty

Relevant Pages

  • Re: Recommendation for a datatype for replication
    ... I've not had any problems using ntext in replication scenarios. ... issues with an ntext column? ... someday when you move from SQL CE to SQL Mobile, ... If the length of the data is 255 characters or less; SQL Server CE ...
    (microsoft.public.sqlserver.ce)
  • RE: ntext column with 256 chars does not ger synch
    ... length greater than 255 characters. ... and a primary key cannot be created on an ntext column. ... I have also a pocket pc with SQL CE 2.0 with the same ... Everytime I sync and the data (SQL ...
    (microsoft.public.pocketpc.developer)
  • Re: Access managment in SQL
    ... > I have just imported my old access database into my new ... then ntext or text is what you want. ... The ncharrequires SQL Server reserve 4000 bytes for each row. ...
    (microsoft.public.sqlserver.clients)
  • EXCEPTION_ACCESS_VIOLATION using ntext
    ... I get the following error when i execute the SQL below. ... It works if the sp parameter is text rather than ntext or if the update uses ... @source int, ...
    (microsoft.public.sqlserver.server)
  • RE: Ntext Field Not Read by BDE
    ... Possibly it can't recognize ntext because it is unicode. ... that does SQL Quering on the SQL table. ... > speaking the BDE either (although it only works on the MSSQL Driver, ... > ntext field to a varchar field, but the other is a commercially available ...
    (microsoft.public.sqlserver.server)