|
|
|
|
|
- Conversion rules
- Miscellaneous
Upper (Function) In french: Majuscule 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|