The following query returns the contents of the Title column, removing any double quotation marks around the text:

SELECT TRIM( BOTH '"' FROM TITLE ) FROM BOOKS

The following query returns all rows where the first three letters of the City column are "San", capitalized in any way:

SELECT * FROM CUSTOMER WHERE UPPER( SUBSTRING( CITY FROM 1 FOR 3 )) = 'SAN'

The following query returns all rows where the letters "n’t" appear in the Title (e.g. "Can’t", "Won’t", "Ain’t", "Don’t"):

SELECT * FROM BOOKS WHERE TITLE LIKE '%n''t%'