SUBSTR and SUBSTRING

Returns a part of a given input string.

SUBSTR is a native SQL function on Oracle and JDBC and a convertible SQL function for USoft.

On all platforms, you can call this function with either 2 or 3 parameters. On SQL Server and ODBC, if you pass 2 parameters, USoft adds the required 3rd parameter before making the database call.

SUBSTRING is a synonym for SUBSTR on all platforms except JDBC, Derby.

Syntax

SELECT     SUBSTR( input-string, from, length )
SELECT  SUBSTRING( input-string, from, length )

The required input-string is the string that the returned substring is of.

The required from is an integer indicating the starting position of the substring within the input string.

The optional length is an integer indicating the length of the substring (Example 1). If omitted, the entire input string after from is returned (Example 2).

Example 1

SELECT  SUBSTR( 'ABCDE', 2, 3 )

This example returns:

BCD

Example 2

SELECT   SUBSTR( 'ABCDE', 2 )

This example returns:

BCDE