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)

REPLACE

  • Last UpdatedDec 19, 2022
  • 1 minute read

For the character expression (s), the REPLACE function finds the character expression (findWhat) and replaces it with another expression (replaceWith).

Syntax

AnsiString REPLACE(s AnsiString, findWhat AnsiString, replaceWith AnsiString)
String REPLACE(s String, findWhat String, replaceWith String)

Arguments

  • s

    The character expression to work within. Must be a character string or an expression resulting in a character string.

  • findWhat

    The character expression to be replaced. Must be a character string or an expression resulting in a character string.

  • replaceWith

    The character expression to insert. Must be a character string or an expression resulting in a character string.

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