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 vote184 views1 answer
Oracle index hint
SQL
2 votes237 views1 answer
Username sql
SQL
0 vote225 views1 answer
What is logical database schema
SQL
2 votes190 views1 answer
Sql column values comma separated
SQL
1 vote212 views1 answer
Oracle activate job
SQL
0 vote188 views1 answer
Inserted row count tsql
SQL
0 vote192 views1 answer
Alasql delete column
SQL
0 vote244 views2 answers
How to truncate all table in mysql workbench
SQL
13 votes189 views2 answers
Sqlite rename column
SQL
0 vote197 views1 answer
Postgres in operator with comma separated values
SQL