Results 1 to 2 of 2

Thread: adding to text

  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: adding to text

    If I have a varchar field, I can easily add to it. For instance
    select 'Name: ' + fname as fname from Customers.

    But what if I have a text field instead of varchar?

    select 'Summary: ' + summary as Summary from Customers won´t work at all.
    Is there a way to accomplish this?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    TEXT columns really ought to be manipulated on the client, not the server. There are a number of reasons for this, most of which are design and performance issues.

    If you really must manipulate a TEXT column on the server, you can use the UPDATETEXT statment, but I'll forewarn you that it is rather ugly.

    You really ought to handle this on the client if you can't make the column a VARCHAR instead of a TEXT column.

    -PatP

Posting Permissions

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