|
|
|
|
- Conversion rules
- Miscellaneous
Lower (Function) In french: Minuscule Converts all characters in a string to lowercase according to the region settings defined in Windows. Remark: Lower 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. Lower("ABCD") // Returns "abcd" Lower("HELLO") Â Â Â Â Â Â // Returns "hello" Lower("Peter and Paul") // Returns "peter and paul"
Syntax
<Result> = Lower(<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.
Remark: Lower 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, Lower has no effect when performing this type of operation.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|