Here we extract the first word of a country name. INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.
Specific to SQLite
none
DB2
Here we extract the first word of a country name. INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.
Specific to DB2
none
MS Access
Here we extract the first word of a country name. INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.
Specific to MS Access
none
PostgreSQL
Here we extract the first word of a country name. INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.
Specific to PostgreSQL
none
Oracle
Here we extract the first word of a country name. INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.
Specific to Oracle
none
MS SQL Server
Here we extract the first word of a country name. INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.
Specific to MS SQL Server
CHARINDEX gives the position, see also PATINDEX
MySQL
Here we extract the first word of a country name. INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.
Specific to MySQL
none
Sybase
Here we extract the first word of a country name. INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.
Specific to Sybase
none
Mimer SQL
Here we extract the first word of a country name. INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.