| SQLite | ||
| 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 | ||
| SQLite | ||
| 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 | ||