String functionsSave PDFSave selected topicSave selected topic and subtopicsSave all topicsShareShare to emailCopy topic URLLast UpdatedSep 29, 20221 minute readPI SystemPI SQL Data Access Server (RTQP Engine) 2023 SP1Developer A set of scalar functions, which operate on string data types, are covered in this section. Related LinksCHARINDEXCONCATFORMAT with a numeric argumentFORMAT with a DateTime argumentINSTRLCASELEFTLENLENGTHLOCATELOWERLTRIMREPLACEREVERSERIGHTRTRIMSUBSTRINGTRIMUCASEUPPER