Right Trim Concatenation

[msrikki]

I am trying to do a simple concatenation for first and last name together, trimming the following blank spaces in the first name. The derived field tests okay, but when I try to use it in the report, I get the following error:

[Oracle][ODBC][Ora]ORA-01722: invalid number

The derived field I am using is:
RTRIM("ECANADA"."PS_PERSONAL_DATA"."FIRST_NAME") +' '+("ECANADA"."PS_PERSONAL_DATA"."LAST_NAME")

 

[CharlesCook]

Try this:

RTRIM("ECANADA"."PS_PERSONAL_DATA"."FIRST_NAME") || ' ' || ("ECANADA"."PS_PERSONAL_DATA"."LAST_NAME")

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining