(string Text)
LEFT returns the first character in a text string.
Example: LEFT(abracadabra) returns (a).
Text: Required. The text string that contains the characters you want to extract.
(string Text, int Length)
LEFT returns the first character or characters in a text string, based on the number of characters
you specify.
Example: LEFT(abracadabra, 3) returns (abr).
Text: Required. The text string that contains the characters you want to extract.
Example
Return the three leftmost characters from string:
left(&SelltoPostCode,3)
Comments
Please sign in to leave a comment.