how to assign text field to a variable in stored procedure

• ikhuram

  SSC Veteran

  Points: 228

  More actions

  May 25, 2004 at 2:08 am

  #180363

  I want to assing text field value to a text type variable. But procedure does not allow to declare any text, ntext and image datatype variables. Please tell me what to do?

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  May 25, 2004 at 5:41 am

  #507620

  Try coverting the text field to (N)VARCHAR (8000) this way the text field will be able to go into the variable

  DECLARE @VAR1 AS VARCHAR(n)

  SET @VAR1 = (SELECT CAST(Textfield AS VARCHAR(n)) FROM dbo.table1)

  Good luck

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net