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

10 votes340 views2 answers
SQL rounding numbers
SQL
0 vote322 views1 answer
How to select an index in oracle sql
SQL
0 vote320 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
1 vote305 views1 answer
Base nosql
SQL
0 vote332 views3 answers
Fetlife
SQL
3 votes298 views1 answer
Oracle user quota unlimited
SQL
7 votes314 views2 answers
Mysql db size
SQL
3 votes279 views1 answer
How to get list of synonyms in oracle
SQL
0 vote348 views1 answer
Sql out file formate
SQL
0 vote288 views10 answers
John the ripper mysql
SQL