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

-1 vote381 views1 answer
Concat two columns in sql server
SQL
0 vote365 views1 answer
Example database query
SQL
0 vote360 views1 answer
Mariadb current date plus 1 day
SQL
2 votes354 views2 answers
How to check data type in sql server
SQL
0 vote356 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote343 views1 answer
Postgres in operator with comma separated values
SQL
2 votes343 views1 answer
Enum in SQL Server
SQL
2 votes396 views3 answers
Mysql kill
SQL
0 vote408 views1 answer
Sql check if field is not null
SQL
1 vote375 views1 answer
Update substring in mysql
SQL