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 vote321 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote273 views2 answers
Identity column in sql server
SQL
-1 vote287 views1 answer
Sql select data from one database and insert into a different database
SQL
1 vote287 views1 answer
Setval pgsql
SQL
11 votes259 views2 answers
Having clause
SQL
0 vote294 views1 answer
Shrink database file in sql server
SQL
2 votes278 views2 answers
How to check data type in sql server
SQL
0 vote293 views1 answer
How to get nth number in sql
SQL
0 vote277 views1 answer
Window function to forward fill
SQL
1 vote275 views1 answer
Show structure of table in sql
SQL