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 vote261 views1 answer
Drop all triggers oracle
SQL
0 vote254 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote289 views1 answer
How to find sql server installation folder
SQL
2 votes259 views1 answer
How to check grants on a package in oracle
SQL
0 vote208 views1 answer
How to get last client id sql
SQL
23 votes296 views5 answers
Sql substring
SQL
0 vote272 views1 answer
How to reset the database value in SQL server
SQL
0 vote261 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
3 votes257 views1 answer
Sql replace character in string in all records
SQL
1 vote255 views1 answer
Oracle convert run duration to number
SQL