|
|
|
|
|
- Conversion rules
- Miscellaneous
Lower (Function) In french: Lower Converts all characters in a string to lowercase according to the region settings defined in Windows. Note: The Lower function is retained for compatibility and works only with Latin character sets.. To configure the formatting of a string more precisely or to handle other character sets, use StringFormat.
Lower("ABCD")
Lower("BONJOUR")
Lower("Pierre et Paul")
Syntax
<Result> = Tiny(<String to convert>)
<Result>: Character string String in lowercase characters. <String to convert>: Character string String to convert to lowercase. Remarks - Unaccented lowercase characters remain unchanged.
- Accented lowercase characters remain unchanged.
- Unaccented uppercase characters are converted to unaccented lowercase characters.
- Accented uppercase characters remain unchanged.
Accented uppercase characters are converted to accented lowercase characters.
Note: The Lower function is retained for compatibility and works only 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, Lower has no effect when performing this type of operation.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|