Merge Columns ?

[#1]

Hi All;

i have 2 columns in my Oracle DB

name surname
Alex Alton
John Dumber
Lisa Sandra

i would like to see this 2 columns in 1 list box(2 columns return to 1 column)

Name&Surname
Alex Alton
John Dumber
Lisa Sandra

How can i do it?

Thanks in advance

[#2 · Accepted solution]

=Name & ' ' Surname

[#3]

=Name & ' ' & Surname

jjj

[#4]

It works but my app slows down !

this list box is slower than others...
so it is useless ?

Is there any way?

[#5]

Create a new column in script level which concatenates both the 'Name' and 'Surname'. You will get a new field and there wont be any performance issue.

e.g. Name &' '&Surname as [Full Name]

-Haneesh

[#6]

Thank you...