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")
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.