DB2 graphic  QMF Version 8

Like any number of characters (percent sign)

You can select rows that contain a string of characters that are part of a word or number that you know exists in the data. In the following query, LIKE %NY in the ADDRESS column means "where the address ends with NY, with anything at all before that."  The percent sign (%) stands for "anything at all" (any number of preceding characters or none).

When you run this query:

Q.APPLICANT | NAME | ADDRESS  |
------------+------+----------|
P.          | AO.  | LIKE %NY |

QMF produces this report:

NAME       ADDRESS
---------  -----------------
JACOBS     POUGHKEEPSIE, NY
LEEDS      EAST FISHKILL, NY
REID       ENDICOTT, NY


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004