substr

Returns a substring of "string_expression" that begins at position "start_integer" and continues for "length_integer" characters. If "length_integer" is not specified, a substring from "start_integer" to the end of "string_expression" is returned.

Syntax

substr ( string_expression , start_integer , length_integer )

Example

substr ( [Sales (query)].[Sales staff].[Position code], 3 , 5 )

Result

Returns characters 3 to 7 of the position codes.