Last Name, First Name

[#1]

Hi,

In my script I have:

Load

     [Last Name],

     [First Name]

From...

Is there a way to join the fields so that the data would appear as "Last Name, First Name" in a list box on the dashboard?

Thank you,

[its_anandrjs]

Load your table like

Load

     '[Last Name] &' , '&[First Name] as Last&Full

From...

[its_anandrjs · Accepted solution]

if you need exactly same as your output that is "Last Name, First Name"

Load

     [First Name],

     [Last Name],

     Chr(34)&[Last Name] &' , '&[First Name]&Chr(34) as Last&Full

From...