Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

Returns the position of the substring found in the string, starting from 1. The returned value is for the first matching value, and not for any subsequent valid matches. In case the substring does not exist, functions will return 0.

​
Syntax

POSITION(<substring> IN <string>)

​
Parameters

ParameterDescriptionSupported input types
<substring>The substring to search for.TEXT
<string>The string that will be searched.TEXT

​
Return Type

INTEGER

​
Example

SELECT
	POSITION('hello' IN 'hello world') AS res;
Returns: 1 
SELECT
	POSITION('world' IN 'hello world') AS res;
Returns: 7 
SELECT
	POSITION('work' IN 'hello world') AS res;
Returns: 0