The jointext function combines two separate text values into one.
jointext( TEXT VALUE1, TEXT VALUE2)
A text value up to 255 characters in length.
When two text values are joined, leading spaces are maintained but trailing spaces are deleted. To join three or more fields, you can use additional jointext functions as either or both parameters.
jointext( "Sapph" , "ire" )
jointext( jointext( "Sapph" , "ire" ) , "International" )
Returns: Sapphire International.
In the above example, there is a space at the start of the string International.
jointext( PRODUCT , " for Windows" )
Returns: DataEase for Windows
In the above example, there is a space at the start of the string for Windows. The PRODUCT field holds the value DataEase.