The LEFT function returns a sub-string from a specified source string, with the length of the sub-string specified and beginning with the left-most character in the string. This function takes two parameters: a source string and the number of characters to extract from the source. If this length is equal to or greater than the length of the source string, the entire string is returned. If the length is 0 or less, an empty string is returned.
- @LEFT (Source
- Source String Required string parameter; contains the source string from which a sub-string will be extracted.
- Length Optional integral number parameter; contains the maximum number of characters to extract from Source String. If this value is equal to or longer than Source String, the entire string is returned. If Length is 0 or less, an empty string will be returned.
Supported Return Types