Ctrlk

CHARINDEX

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:

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|

PreviousCHAR NextCOALESCE

Last updated 3 years ago

Was this helpful?

hashtagDescription

hashtagSample Source Pattern

hashtagSyntax

hashtagExamples

Description

Sample Source Pattern

Syntax

Examples