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.
Accented uppercase characters are converted to accented lowercase characters.
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.