String & binary functions

Function	Support	Notes
`ASCII`	Supported
`CONCAT`	Supported
`LEFT`	Supported
`LENGTH`	Supported
`LIKE`	Supported
`LOWER`	Supported
`LPAD`	Supported
`LTRIM`	Supported
`MD5`	Supported
`OCTET_LENGTH`	Supported
`POSITION`	Supported
`REPEAT`	Supported
`REVERSE`	Supported
`RIGHT`	Supported
`RPAD`	Supported
`RTRIM`	Supported
`SPLIT_PART`	Supported
`SPLIT`	Supported
`SUBSTRING`	Supported
`SUBSTR`	Supported
`TRIM`	Supported
`UPPER`	Supported
`CONTAINS`, `REPLACE`	With limitations	Available for some argument types only.
`SOUNDEX`	With limitations	Runs, but the result differs from Snowflake.
`BASE64_ENCODE`, `BINARY_AS_STRING`, `BIT_LENGTH`, `CHAR`, `CHARINDEX`, `CHR`, `CONCAT_WS`, `EDITDISTANCE`, `ENDSWITH`, `FORMAT_STRING_TEMPLATE`, `FUZZY_SUBSEQUENCE_SCORE`, `HEX_ENCODE`, `ILIKE`, `INITCAP`, `INSERT`, `JACCARD_SIMILARITY`, `JAROWINKLER_SIMILARITY`, `LEN`, `LIKE_ANY`, `MD5_BINARY`, `MD5_HEX`, `RTRIMMED_LENGTH`, `SHA1`, `SHA1_BINARY`, `SHA1_HEX`, `SHA2`, `SHA2_BINARY`, `SHA2_HEX`, `SOUNDEX_P123`, `SPACE`, `STARTSWITH`, `STRING_AS_BINARY`, `STRTOK`, `STRTOK_TO_ARRAY`, `TRANSLATE`, `TRY_BASE64_DECODE_BINARY`, `TRY_BASE64_DECODE_STRING`, `TRY_HEX_DECODE_BINARY`, `TRY_HEX_DECODE_STRING`, `TRY_VALIDATE_UTF8`, `UNICODE`	Not supported

Limitations

SOUNDEX differs in the case of the leading character only: SOUNDEX('robert') returns R163, where Snowflake returns r163.