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

2 votes192 views1 answer
Plsql block
SQL
0 vote203 views1 answer
Trigger stock phpmyadmin output message
SQL
6 votes254 views1 answer
Postgresql get year
SQL
0 vote277 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote198 views1 answer
Dns slave zone convert
SQL
0 vote280 views1 answer
Sql delete row from table where id
SQL
17 votes330 views4 answers
Show all tables in oracle
SQL
0 vote189 views1 answer
CREATE MULTIPLE FK
SQL
1 vote192 views3 answers
How to truncate foreign key constraint table
SQL
0 vote212 views1 answer
How to put value in parameters in mysqldataadapter
SQL