strposb(source text, target text)

Let us now check the strposb(source,target) function with the following query.

Query

default> select strposb('tutorialspoint','tutorial') as location;

Result

The above query will generate the following result.

location 
------------------------------- 
1

The output returns the binary string position for the given string.