Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI SQL Data Access Server (RTQP Engine)

SUBSTRING

  • Last UpdatedDec 19, 2022
  • 1 minute read

The SUBSTRING function returns a substring from the specified character expression (s) starting at the specified position (n) and including the specified number of characters (m).

Syntax

AnsiString SUBSTRING(s AnsiString, n Int32, m Int32)
String SUBSTRING(s String, n Int32, m Int32)

Arguments

  • s

    Must be a character string or an expression resulting in a character string.

  • n

    Must be an integer.

  • m

    Must be an integer.

In This Topic
Related Links
TitleResults for “How to create a CRG?”Also Available in