text, ntext data types problems in SQL Function

• gmsaiful

  SSC Rookie

  Points: 42

  More actions

  July 4, 2008 at 6:17 am

  #99164

  I have a table with data type text column. while using text type variables in function I get error like The text, ntext, and image data types are invalid for local variables.

  For now I am using VARCHAR(MAX) type variables in function but I cant get whole text of that field. I am losing lots of data from that function and my query output is not precise.

  How can I use text/ntext data type in SQL Function to get precise output?

  Thanks in advance.

• dbo.benyos

  SSCommitted

  Points: 1944

  More actions

  July 4, 2008 at 7:34 am

  #838359

  Hi

  What is your function doing with such a long text?

  There are some ways to get a round this limit, but usually you do not want to process such long texts.

  Post some more details and I'll be happy to solve your problem.

  Tal Ben Yosef

  Tal Ben Yosef
  www.TalBenYosef.com
  (visit my LinkedIn profile)