Differences

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

--- syntax:functions:right [2021/07/28 01:04] – craigt
+++ syntax:functions:right [2021/08/14 22:30] (current) – [Examples] craigt
@@ Line 27: / Line 27: @@
 =====Examples=====
-  right('Los Angeles', 3) = 'les'
+  right('Los Angeles', 3) //Returns 'les'
-  right('IT services', 8) = 'services'
-  right('Canada',10) = 'Canada'
+  right('IT services', 8) //Returns 'services'
-  right('EasyMorph',0) = ''  //Empty value
-  right(12345, 3) = '345'  //Note, the numeric value of 12345 was passed in.  The result is a text value.
+  right('Canada',10) //Returns 'Canada'
-  right(#2021-10-21, 3) = '490'  //2021-10-21 is 44490 as a converted date serial value, so '490' is returned.
-  right(100*3, 1) = '0'  //The result of 100 * 3 = 300, so the '0' is returned as the single rightmost character.
+  right('EasyMorph',0) //Returns ''  (Empty value)
+  right(12345, 3) //Returns '345'  (Note, the numeric value of 12345 was passed in.  The result is a text value.)
+  right(#2021-10-21, 3) //Returns '490'  (2021-10-21 is 44490 as a date serial value, so '490' is returned.)
+  right(100*3, 1) //Returns '0'  (The result of 100 * 3 = 300, so '0' is returned as the rightmost character.)
 \\
 ===== See also =====
-  * [[syntax:functions:right]]
+  * [[syntax:functions:left|Left(text, no_of_chars)]]
-  * [[syntax:functions:mid]]
+  * [[syntax:functions:mid|Mid(text, N, K)]]