'Split' Function

[Halo]

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]

[lesstjm]

select customer||client from table_name;