I want to create Full Name by using existing First Name and Last Name

[Eswar75]

hi
I want to create Full Name object by using existing First Name and Last Name objects in BO Designer.My database is DB2.

thank u in advance

 

[jobjoris]

DB2 knows the concat-function in its SQL. So it would be something like:

CONCAT(TABLE.FORNAME,TABLE.SURNAME)

 

[blom0344]

You may want to have a space between the names, like:

TABLE.FIRSTNAME||' '||TABLE.SURNAME

|| works usually as a concat function

T. Blom
Information analyst
tbl@shimano-eu.com

 

[BrianTyler]

There are a couple of other points here.

Firstly, if any of the fields being concatenated 'contains' null, the resultant string is null, so it may me useful to coalesce the fields first (i.e. change Null to Space).

Secondly, it could be useful to RTRIM the fields to remove any trailing spaces ion each element, and then to put one space back as was suggested.

rtrim(coalesce(TABLE.FIRSTNAME,' ')||' '||coalesce(TABLE.SURNAME,' ')

 

[blom0344]

Good additional points, Brian...

T. Blom
Information analyst
tbl@shimano-eu.com