SQL · Functions and expressions

position()

Finds a substring position, returning 0 when absent. SQLite uses instr().

sqlRunnable example sql course

Syntax

position('x' in text)

Example

Open in the lab

SELECT instr('EduByte', 'Byte') AS at;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.