Case Function

Description:

Apply a specified case to some text.

Returns:

Text

Parameter:

Parameter	Data Type	Description
1	Text	The text.
2	Text	The case.

Examples:

When using functions inside a field, remember the field brackets:

{Case(BuyerName, "upper")}

Note you can also achieve this using the format keyword in a field:

{BuyerName Format Upper}

Expression	Result
Case( "111 ninth avenue,new york,usa", "upper" )	"111 NINTH AVENUE,NEW YORK,USA"
Case( "111a ninth avenue,new york,USA", "lower" )	"111a ninth avenue, new york,usa"

This article applies to: