DB2 graphic  QMF Version 8

Ignore characters: LIKE '_a_'

You can use the underscore (_) to specify a character string that ignores a given number of characters. Use a specific number of underscores to specify the same number of characters that are to be ignored in the search. For example,

WHERE PARTNO LIKE '_G2044_ _'

is used to search a column of eight character part numbers for the combination "G2044" occurring in positions 2 through 6. The first and last two characters are ignored. Single quotes are required around an all-digit value in z/OS.

Examples:


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