Try Opteryx

SUBSTRING

Extracts a substring starting at the specified position with optional length.

Category: String Functions

Syntax

sql
SUBSTRING(str FROM start)
sql
SUBSTRING(str FROM start FOR length)

Arguments

  • string varchar String input value.
  • from_pos integer Integer input value.
  • count integer Integer input value.

Returns

same as string — Returns a value with the same type as string.

Usage Notes

Canonical SQL-92 form is SUBSTRING(str FROM start FOR length). Opteryx also accepts SUBSTRING(str[, start[, length]]).