novels=# select * from authors where name like 'Colm%';
   id  |    name     | upper_name
  -----+-------------+-------------
   100 | Colm Tóibín | COLM TóIBíN
  (1 row)