SnowConvert - Translation Spec
search
⌘Ctrlk
SnowConvert - Translation Spec
  • For Teradata
  • Translation Reference
    • Teradata
    • Oracle
    • SQLServer
      • General Language Elements
      • DDLs
      • DMLs
      • Data Types
      • Statements
      • Built-in functions
        • SnowConvert custom UDFs
        • Aggregate functions
        • Analytic Functions
        • Conversion functions
        • Data Type functions
        • Date & Time functions
        • Logical functions
        • Mathematical functions
        • Metadata functions
        • Ranking functions
        • String functions
          • ASCII
          • CHAR
          • CHARINDEX
          • COALESCE
          • CONCAT
          • CONCAT_WS
          • DIFFERENCE
          • FORMAT
          • LEFT
          • LEN
          • LOWER
          • LTRIM
          • NCHAR
          • PATINDEX
          • QUOTENAME
          • REPLACE
          • REPLICATE
          • REVERSE
          • RIGHT
          • RTRIM
          • SOUNDEX
          • SPACE
          • STR
          • STRING_ESCAPE
          • SUBSTRING
          • TRIM
          • UPPER
        • System functions
        • XML Functions
      • Built-in procedures
      • Snowflake Scripting
      • System Tables
      • Queries
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 2 years ago