Skip to main content

MID

Builds a substring by starting at the position specified and reading until either the end of the string is reached or, if specified, length is exceeded.

Syntax

MID ( string_expression, start_pos [, length] ) 

Arguments

string_expression
A valid string expression.

start_pos The position to start reading from as a numeric value.

length The number of characters to be returned as a numeric value.

Remarks

  • The first position in the string is 1.
  • If the start position exceeds the length of the string, an empty string is returned.

Return Type

Returns values of type STRING.

Examples

Examples in this section use the example blockchain.

The following example calculates the MID for the specified components.

SELECT MID(str, 2, 4) FROM example;

Response:

MID(str, 2, 4) [STRING]
NULL

ect
iale