Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: how to select the content of the text field into variable

    i want to select the content of text field from a table, i need to process this text field values,but i am fail to put the values of text field into a variable,how to declare the type of variable,and how i can do???

  2. #2
    Join Date
    Sep 2003
    Posts
    14
    Try

    declare @text varchar(100)
    select @text = ""

    select @text = field.table_name from table_name

    All the Best!!!

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Originally posted by usha_nandini
    Try

    declare @text varchar(100)
    select @text = ""

    select @text = field.table_name from table_name

    All the Best!!!
    This statment will truncate zour TEXT field !

    Replacing a question with a question : why do you use TEXT fields (difficult to manage) ? Till ASE 12.5, you can bypass the limitation of the 255 varchars

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •