Returns a specified number of characters from a string.
Syntax
Copy Code
|
---|
string Mid ( string value, int pos, int length ) |
Parameters
- value
- A string expression from which characters are returned. If value is null, null is returned.
- pos
- The zero-based starting character position in value of the substing to be returned. If pos is greater than the number of characters in value, the function returns an empty string ("").
- length
- The number of characters to return. If there are fewer than length characters in the string, all characters from pos to the end of the string are returned.
Remarks
To determine the number of characters in a string, use the Len function.
See Also
Text Functions
Left Function
Right Function
Len Function