CHARINDEX

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Applies to

SQL Server
Azure Synapse Analytics

Description

Returns the index of the first occurrence of the specified value sent as a parameter when it matches (CHARINDEX in Transact-SQL).

Sample Source Pattern

Syntax

CHARINDEX( expression_to_find, expression_to_search [, start] )

Examples

Code:

IN -> SqlServer_01.sql

SELECT CHARINDEX('t', 'Customer') AS MatchPosition;

Result:

      INDEX|      
-----------+
         33|

Indexes in Transact start at 1, instead of JavaScript which start at 0.

Code:

CREATE OR REPLACE FUNCTION get_index
(
  expression_to_find varchar, 
  expression_to_search varchar, 
  start_index  float
)
  RETURNS float
  LANGUAGE JAVASCRIPT
AS
$$
  return EXPRESSION_TO_SEARCH.indexOf(EXPRESSION_TO_FIND, START_INDEX)+1;
$$;

SELECT GET_INDEX('and', 'Give your heart and soul to me, and life will always be la vie en rose', 20) AS INDEX;

Result:

      INDEX|      
-----------+
         33|

Known Issues

No issues were found.

No related EWIs.

PreviousCHAR NextCOALESCE

Last updated 4 months ago

Description

Sample Source Pattern

Syntax

Examples

Known Issues

Related EWIs