DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: 'Split' Function

Hybrid View

  1. #1
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759

    Angry

    I am trying to concatenate 2 fields using substrings by the use of a function.
    Consider the example:
    Customer Client
    A 1
    A 2
    A 3
    B 4
    B 1
    B 2
    How can I get the following:
    Customer||Client
    A1
    A2
    B4
    B1
    -
    Basically, I would like to get the correct Client for the correct Customer, since the Client name is repeated over and over. Or is there a better way to do this?? If so, how??
    Thanx in advance.


    [Edited by Halo on 03-27-2001 at 03:27 PM]

  2. #2
    Join Date
    Jan 2001
    Posts
    515

    answer

    select customer||client from table_name;

Posting Permissions

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


Click Here to Expand Forum to Full Width