LEFT Function
Function Type | Predefined function | |
Syntax | LEFT( <stringValue>, <integerCount> ) | |
Description | Returns a string containing a specified number of characters starting from the left side of a string. | |
Argument | Description | |
<stringValue> | String value from which the left most characters are returned. | |
<integerCount> | Number of characters to return from the left. <integerCount> must be between 0 and approximately 65,500, inclusive. If <integerCount> is zero, the return value will be a zero-length string. If <integerCount> is greater than or equal to the number of characters in <stringValue>, the entire string is returned. | |
Returns | String | |
Example | This example returns the value of the two left most characters in a variable called MyText. LEFT(VAR.MyText,2) | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*