Sql

Search

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*/)

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql order by alphabetical
Sql :: Converting mysql tables to charset utf8mb4
Sql :: mysql count multiple columns in one query
Sql :: mariadb date equals to current_date plus days
Sql :: how to change column name in mysql
Sql :: flask marshmallow sqlalchemy
Sql :: change password postgres pgserver
Sql :: mysql order by
Sql :: get yesterday date ISO in psql
Sql :: sql convert date format
Sql :: how to delete data from sql database in android
Sql :: mysql change value
Sql :: sql find table by name
Sql :: oracle insert into where
Sql :: delete row by id mysql
Sql :: sql query to find percentage of null values in a table
Sql :: postgresql check total storage
Sql :: Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
Sql :: lower case in sql
Sql :: alter table query sql server change column
Sql :: insert into auto increment mysql
Sql :: select true if exists on another table or false sqlserver
Sql :: Using GROUP BY in MySQL Join Table
Sql :: get triggers by query
Sql :: mysql remove unique key
Sql :: distinct in sql server
Sql :: update multiple columns in sql
Sql :: mysql not empty
Sql :: update table sql multiple set
Sql :: sql datum formatieren

Search

SQL

sql character index

ADD CONTENT