Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 1 of 1 total
Thread computed fields, FullName (from SurName, FirName, MidNames)
Wed, Feb 8 2012 7:35 AMPermanent Link

Lucian

/*********************************************/
/* FullName: from SurName, FirName, MidNames */
/* result: SurName, FirName MidNames         */
/*********************************************/

IF (SurName <> '' THEN
 IF (FirstName <> '' THEN
   IF (MidNames <> '' THEN SurName + ', ' + FirName + ' ' + MidNames ELSE SurName + ', ' + FirName)
 ELSE
   IF (MidNames <> '' THEN SurName + ', ' + MidNames ELSE SurName))
ELSE
 IF (FirstName <> '' THEN
   IF (MidNames <> '' THEN FirName + ' ' + MidNames ELSE FirName)
 ELSE
   IF (MidNames <> '' THEN MidNames ELSE '')))
Image