Difference between revisions of "Label Functions"
| Line 3: | Line 3: | ||
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 == | ||
| Line 32: | Line 31: | ||
== LOWERCASE == | == LOWERCASE == | ||
<br> | <br> | ||
| − | Syntax < | + | Syntax < LOWERCASE(string)><br> |
| − | example < | + | example < LOWERCASE(<* DESCRIPTION*>)><br> |
== TRIM == | == TRIM == | ||
<br> | <br> | ||
| − | Syntax < RIGHT(string | + | Syntax < RIGHT(string)><br> |
| − | example < RIGHT(<* | + | example < RIGHT(<* DESCRIPTION*>)><br> |
== LTRIM == | == LTRIM == | ||
<br> | <br> | ||
| − | Syntax < RIGHT(string | + | Syntax < RIGHT(string)><br> |
| − | example < RIGHT(<* | + | example < RIGHT(<* DESCRIPTION*>)><br> |
== RTRIM == | == RTRIM == | ||
<br> | <br> | ||
| − | Syntax < RIGHT(string | + | Syntax < RIGHT(string)><br> |
| − | example < RIGHT(<* | + | example < RIGHT(<* DESCRIPTION*>)><br> |
== TIMESTAMP == | == TIMESTAMP == | ||
Revision as of 13:00, 7 March 2014
Contents
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
Syntax < PADLEFT(string,len,char)>
example < PADLEFT(<* PROD_QUANTITY*>,4,0)>
PADRIGHT
Syntax < PADRIGHT(string,len),char>
example < PADRIGHT(<*PROD_QUANTITY*>,4,)>
UPPERCASE
Syntax < UPPERCASE(string)>
example < UPPERCASE(<*DESCRIPTION*>)>
LOWERCASE
Syntax < LOWERCASE(string)>
example < LOWERCASE(<* DESCRIPTION*>)>
TRIM
Syntax < RIGHT(string)>
example < RIGHT(<* DESCRIPTION*>)>
LTRIM
Syntax < RIGHT(string)>
example < RIGHT(<* DESCRIPTION*>)>
RTRIM
Syntax < RIGHT(string)>
example < RIGHT(<* DESCRIPTION*>)>
TIMESTAMP
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
USERNAME
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
VERSION
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
IIF
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
EXPIRYDATE
Syntax < RIGHT(string,len)>
example < RIGHT(<*SSCC*>,3)>
