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 vote257 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote205 views1 answer
How to drop function in sql
SQL
0 vote193 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote192 views1 answer
Oracle activate program
SQL
9 votes223 views6 answers
Oracle substring
SQL
0 vote207 views1 answer
How to reset the database value in SQL server
SQL
0 vote207 views1 answer
Mysql average from two table
SQL
3 votes213 views1 answer
Oracle apex call duration
SQL
0 vote193 views1 answer
Oracle archivelog usage
SQL
1 vote205 views2 answers
Postgresql get difference in hours between two dates
SQL