SnowConvert - Translation Spec
search
Ctrlk
  • For Teradata
  • Translation Referencechevron-right
    • Teradatachevron-right
    • Oraclechevron-right
    • SQLServerchevron-right
      • General Language Elementschevron-right
      • DDLschevron-right
      • DMLschevron-right
      • Data Types
      • Statementschevron-right
      • Built-in functionschevron-right
        • SnowConvert custom UDFschevron-right
        • Aggregate functionschevron-right
        • Analytic Functionschevron-right
        • Conversion functionschevron-right
        • Data Type functionschevron-right
        • Date & Time functionschevron-right
        • Logical functionschevron-right
        • Mathematical functionschevron-right
        • Metadata functionschevron-right
        • Ranking functionschevron-right
        • String functionschevron-right
          • ASCIIchevron-right
          • CHAR
          • CHARINDEX
          • COALESCE
          • CONCAT
          • CONCAT_WSchevron-right
          • DIFFERENCEchevron-right
          • FORMATchevron-right
          • LEFT
          • LEN
          • LOWER
          • LTRIMchevron-right
          • NCHAR
          • PATINDEXchevron-right
          • QUOTENAMEchevron-right
          • REPLACE
          • REPLICATE
          • REVERSEchevron-right
          • RIGHT
          • RTRIM
          • SOUNDEXchevron-right
          • SPACE
          • STRchevron-right
          • STRING_ESCAPEchevron-right
          • SUBSTRING
          • TRIMchevron-right
          • UPPER
        • System functionschevron-right
        • XML Functionschevron-right
      • Built-in procedureschevron-right
      • Snowflake Scriptingchevron-right
      • System Tableschevron-right
      • Querieschevron-right
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. Translation Referencechevron-right
  2. SQLServerchevron-right
  3. Built-in functions

String functions

This section describes the functional equivalents of string functions in Transact-SQL to Snowflake SQL and JavaScript code, oriented to the creation of UDFs in Snowflake.

ASCIIchevron-rightCHARchevron-rightCHARINDEXchevron-rightCOALESCEchevron-rightCONCATchevron-rightCONCAT_WSchevron-rightDIFFERENCEchevron-rightFORMATchevron-rightLEFTchevron-rightLENchevron-rightLOWERchevron-rightLTRIMchevron-rightNCHARchevron-rightPATINDEXchevron-rightQUOTENAMEchevron-rightREPLACEchevron-rightREPLICATEchevron-rightREVERSEchevron-rightRIGHTchevron-rightRTRIMchevron-rightSOUNDEXchevron-rightSPACEchevron-rightSTRchevron-rightSTRING_ESCAPEchevron-rightSUBSTRINGchevron-rightTRIMchevron-rightUPPERchevron-right
PreviousROW_NUMBERchevron-leftNextASCIIchevron-right

Last updated 1 year ago