A Gentle Introduction to

SQL

FUNCTIONS

How to use string functions, logical functions and mathematical functions.


Finding a substring in a string
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.
db2 variations:
None

access
db2
mysql
oracle
postgres
sqlserver