How to concatenate two text fields with space in between

[ashishh]

I would like to print a concatenated "First Name" and "Last Name" with a space between. How can I achieve this?

Thanks,
Ashish

 

[rhinok]

{table.firstname}+" "+{table.lastname}

 

[ashishh]

I have tried this before. It does not work. To give a background, I am using this SQL Expression field in CR8.5 and want to print it this way.

FirstName LastName

 

[CuteGeek]

Example:
{FirstName} + {LastName}

You have to put a space before and after +

 

[synapsevampire]

That depends on the database, but if you're using the SQL Expression, it would likely be:

{table.firstname}+' '+{table.lastname}

It may also be that you need:

ltrim(rtrim({table.firstname}))+' '+{table.lastname}

(sorry if this posts multiple times, having problems today with connectivity)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ashishh]

Yes. It does work. I had been trying to use with double quotes and that's what was not working.

Thanks for your help guys.

Ashish