In the following example, the SUBSTR function is used to reduce the firstname to one letter, to provide it with a period and a blank and then to concatenate it with the name.
SELECT SUBSTR(firstname,1,1)&'. '&name name, city
FROM customer
WHERE firstname IS NOT NULL
