/* String functions */

SELECT fname, lname, lname || ' ' || fname  AS  fullname        /* concatenate */
FROM   student;                                                 /* in Oracle and SQLite*/

SELECT fname, lname, CONCAT(lname, ' ', fname) AS  fullname     /* concatenate */
FROM   student;                                                 /* in Mysql    */

SELECT fname, lname, sex
FROM   instructor
WHERE  LOWER(lname) = 'sultan';

SELECT RTRIM(fname), RTRIM(lname) 
FROM   student;

SELECT description, LENGTH(description)
FROM   course;

SELECT course_id, description, REPLACE(description, 'XML', 'SQL')
FROM   course;

SELECT course_id, SUBSTR(description, 10, 5)     
FROM   course;                                    

SELECT description, INSTR(description, 'dev')
FROM   course;

SELECT address.*, IFNULL(street2,'-')           /* for Oracle use */
FROM   address;                                 /* NVL(...)       */