How do I find the first position of a string within a string with SQL?

Depending on the database you’re using, the function will be called differently and may have different syntax.

MySQL, vertica instr(full string, string to search)
PosgreSQL position(string to search in full string)
SQL Server charindex(string to search, full string, {starting position})

As you might have noticed, the function in SQL Server has an additional argument, allowing you to search starting from any point within the full string.

The most valuable usage of these functions, however, is not in finding the exact starting position of the string per se, but rather in checking if a string exists within another…

If the function results in 0, that will indicate that the full string does not contain the one being searched

Wanna see a real-life example?