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

21 votes303 views6 answers
Change column in mysql
SQL
0 vote344 views1 answer
Mysql dump for selected row
SQL
0 vote311 views1 answer
Search from comma separated values in sql server
SQL
5 votes284 views1 answer
Oracle asynchronous query
SQL
0 vote316 views1 answer
How to install sql in anaconda
SQL
0 vote281 views1 answer
What is mysql_pconnect
SQL
0 vote298 views1 answer
Mysql where in keep order
SQL
1 vote286 views1 answer
Oracle list data files
SQL
0 vote389 views1 answer
Play framework connection via windows sql server
SQL
0 vote282 views2 answers
Sql update top 100
SQL