Sql character index

-- EXAMPLE
select 
	'0004V0' as TESTER_STRING
	, CHARINDEX('V','0004V0') -- OUTPUT: 5
	, CHARINDEX('0','0004V0') -- OUTPUT: 1
	, CHARINDEX('0','0004V0',4) -- OUTPUT: 6
from DUAL;

-- SYNTAX
CHARINDEX(/*substring*/, /*Main string*/, /*start index*/)

Similar codes

0 vote320 views1 answer
How to find date from date table in sql
SQL
0 vote290 views1 answer
Sql convert float to string
SQL
0 vote275 views1 answer
How to find database collation in postgres
SQL
4 votes275 views1 answer
Wilayah indonesia sql
SQL
0 vote337 views1 answer
Postgres rename database
SQL
0 vote317 views1 answer
Get statis values sql
SQL
0 vote286 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
2 votes300 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
18 votes284 views3 answers
Mysql query add column with default string value
SQL
2 votes294 views2 answers
Postgresql search all tables for column name
SQL