substrb

Returns the substring of "string_expression" that starts at position "numeric_expression1" and ends after "numeric_expression2" bytes. The first byte in "string_expression" is at position 1. If you omit "numeric_expression2", returns the substring of "string_expression" that starts at position "numeric_expression1" and ends at the end of "string_expression".

Syntax

substrb ( string_expression , numeric_expression1 [ ,
 numeric_expression2 ] )

Example

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

Result

Returns characters 3 to 7 of the position codes.