Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB Extensions
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 1 of 1 total
computed fields, FullName (from SurName, FirName, MidNames)
Wed, Feb 8 2012 7:35 AM
Permanent 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 '')))