Results 1 to 2 of 2

Thread: SQL Column Concatination

  1. Jun 30th, 1999, 11:07 AM #1
    Scuzy
    Scuzy is offline

    Thread Starter
    New Member
    Join Date
    Apr 1999
    Location
    Clark County Washington
    Posts
    6

    Post

    Im trying to combine several fields into one single field previous to a INSERT INTO call. I have tried the following statement "Select Field1+Field2+Field3 AS NewField from table" and the NewField gets created but it is empty. Any Ideas??
    Reply With Quote Reply With Quote
  2. Jun 30th, 1999, 05:03 PM #2
    bashfirst
    bashfirst is offline
    Lively Member
    Join Date
    Jun 1999
    Location
    Raleigh, NC
    Posts
    70

    Post

    Could it be a data type problem? Should your concatenation character be a & or | | instead?
    Bash
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width