Difference between revisions of "Label Functions"

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

Revision as of 12:55, 7 March 2014

SUBSTRING


Syntax <SUBSTRING(string,start,len)>
Example <SUBSTRING(<*SSCC*>,1,3)>


LEFT


Syntax <LEFT(string,len)>
example <LEFT(<*SSCC*>,3)>

RIGHT


Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>

PADLEFT

PADRIGHT

UPPERCASE

LOWERCASE

TRIM

LTRIM

RTRIM

TIMESTAMP

USERNAME

VERSION

IIF

EXPIRYDATE