Difference between revisions of "Label Functions"

From Commander4j Wiki
Jump to: navigation, search
Line 1: Line 1:
 
== SUBSTRING ==
 
== SUBSTRING ==
  
syntax <SUBSTRING(string,start,len)>
+
syntax <SUBSTRING(string,start,len)><br>
example <SUBSTRING(<*SSCC*>,1,3)>
+
example <SUBSTRING(<*SSCC*>,1,3)><br>
  
  

Revision as of 13:53, 7 March 2014

SUBSTRING

syntax <SUBSTRING(string,start,len)>
example <SUBSTRING(<*SSCC*>,1,3)>


LEFT

example <LEFT(<*SSCC*>,1,3)>

RIGHT

PADLEFT

PADRIGHT

UPPERCASE

LOWERCASE

TRIM

LTRIM

RTRIM

TIMESTAMP

USERNAME

VERSION

IIF

EXPIRYDATE