Differences

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

--- syntax:functions:upper [2015/03/29 21:49] – elenap
+++ syntax:functions:upper [2021/08/14 22:24] (current) – [Examples] craigt
@@ Line 1: / Line 1: @@
-===== Upper(text) =====
+====== Upper(text) ======
+Category:  Text function
-Returns //text// converted into uppercase letters. Can be used with //'text'// or //[field]// - see Example 2.
+\\
+=====Description=====
+This function returns //text// converted to uppercase letters.
-^  Example  ^  Result  ^
+\\
-|  upper('Health Services')  |  HEALTH SERVICES  |
+=====Use cases=====
-|  upper([city])  |  (returns text in uppercase 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:lower|Lower(text)]] function can also be used for this.
-**See also**
+\\
-  * [[syntax:functions:lower]]
+=====Arguments=====
+^Argument^Type^Description^
+|text|Text|The text value to convert to uppercase.|
+**Return value type:** Text
+\\
+=====Remarks=====
+This function has no effect on numbers, symbols, or non-printing characters.
+\\
+=====Examples=====
+  upper('Health Services') //Returns 'HEALTH SERVICES'
+  upper('all lowercase') //Returns 'ALL LOWERCASE'
+  upper([Industry]) //Returns 'ENERGY'  (Using a field name; [Industry] = 'Energy')
+  upper([YourIndustry]) = upper([MyIndustry])  (Case insensitive comparison between two fields)
+\\
+===== See also =====
+  * [[syntax:functions:lower|Lower(text)]]
+  * [[syntax:functions:proper|Proper(text)]]