Mid

Returns a specified number of characters from a string.

Syntax

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