Mid()

Returns a specific number of characters from specified string expression string starting at the specified start position (1-based).

Syntax

Mid(string stringExpression, double startPosition, double numberOfCharacters)

 

  • Expression: name of the expression
  • startPosition: where to start counting in the expression
  • numberOfCharacters:  number of characters to return

Example

 

Mid("Well name", 2, 2) returns "ll"