Examples

• If FNAME is CHAR(6) with a value of BEN, and LNAME is CHAR(8) with a value of JOHNSON, FNAME CONCAT LNAME results in BEN JOHNSON with a length of 14. (There are three blank spaces between the first and the last names.)

  This example requires a specific release of DB2 or SQL/DS. See Appendix C. QMF Functions that Require Specific Support.

• This query lists all last names in Q.INTERVIEW that begin with letters greater than M, and combines those last names with their respective first names.

  SELECT LASTNAME CONCAT ', ' CONCAT FIRSTNAME
  FROM Q.INTERVIEW
  WHERE LASTNAME > 'M'