Differences

This shows you the differences between two versions of the page.

--- syntax:functions:lower [2015/03/27 15:08] – elenap
+++ syntax:functions:lower [2021/08/02 03:10] – craigt
@@ Line 1: / Line 1: @@
-===== Lower(text) =====
+====== Lower(text) ======
+Category:  Text function
-Returns //'text'// converted into lowercase letters. Can be used with //'text'// or //[field]// - see Example 2.
+\\
+=====Description=====
+This function returns //text// converted to lowercase letters.
-^  Example  ^  Result  ^
+\\
-|  lower('Customer Service')  |  customer service  |
+=====Use cases=====
-|  lower([industry])  |  (returns text in lowercase letters)  |
+This function can be used to perform a case-insensitive comparison of text values when the current case of the values are not known.  The [[syntax:functions:Upper|Upper(text)]] function can also be used for this.
-Note: To test Example 2 in EasyMorph need to use table with a column "industry"
+\\
+=====Arguments=====
+^Argument^Type^Description^
+|text|Text|The text value to convert to lowercase.|
-**See also**
+**Return value type:** Text
-  * [[syntax:functions:upper]]
+\\
+=====Remarks=====
+This function has no effect on numbers, symbols, or non-printing characters.
+\\
+=====Examples=====
+  lower('Customer Service') = 'customer service'
+  lower('IN ALL CAPS') = 'in all caps'
+  lower([Industry]) = 'energy'  //Using a field name; [Industry] = 'Energy'
+  lower([YourIndustry]) = lower([MyIndustry])  //Case insensitive comparison between two fields
+\\
+===== See also =====
+  * [[syntax:functions:upper|Upper(text)]]