Application icon

Case

The purpose of this statement is to apply case transformations in one or more fields, a named variable or each item of a list in a named variable. The statement can specify any of the case transformation operations described in Alphabetic Case Transformations. What fields or text strings you are processing is discussed in Statement Source/Target Determination.

Note that the optional field exception setting is not available when the source is Named Variable. Optional field exceptions are validated immediately when the source is Fields in Table. When the source is Fields in Named Variable if a runtime check determines that the optional field exception is one of the specified fields, it is silently ignored.

Note that Runtime is a special mode. Runtime reads the value of named variable Runtime Case Transformation to determine the appropriate case transformation. The following list describes the values you can set for each transformation. The values are case insensitive. Any values other than those described is equivalent to No Change.

No Change
0, N, no change, none
lower
1, L, lower, lower case, lowercase
Upper
2, U, upper, upper case, uppercase
Capitalize
3, C, capitalize
Capitalize first
4, F, capitalize first, first
Title Case
5, T, title case, title
lower-Title Case
6, M, lower-title case, lower-title
Sentence case
7, S, sentence case, sentence


Field Selection Modes in Tables