Converts all characters in a string to uppercase according to the region settings defined in Windows.
Remark:
Upper is kept for backward compatibility and can only be used with Latin character sets. To configure the formatting of a string more precisely or to handle other character sets, use
StringFormat.
Upper("abcd") // Returns "ABCD"
Upper("élan") // Returns "ELAN"
Upper("this!") // Returns "THIS!"
Syntax
<Result> = Upper(<String to convert>)
<Result>: Character string
String in uppercase characters.
<String to convert>: Character string
String to convert to uppercase.
Remarks
- Unaccented lowercase characters are converted to unaccented uppercase characters.
- Accented lowercase characters are converted to unaccented uppercase characters.
Accented lowercase characters are converted to accented uppercase characters. - Unaccented uppercase characters remain unchanged.
- Accented uppercase characters remain unchanged.
Remark:
Upper is kept for backward compatibility and can only be used with Latin character sets. To configure the formatting of a string more precisely or to handle other character sets, use
StringFormat.
- "Whitespaces" are kept.
- The HFSQL engine automatically performs case-insensitive searches. Therefore, Upper has no effect when performing this type of operation.