LIKE predicate


The LIKE predicate supports only character data (no graphics).

It also supports patterns constructed dynamically.

Information
Example
A1 LIKE SUBSTR(A2,1,1)||'%'||'CDE' 

A1 and A2 represent character columns.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Utility Manager for Db2 13.1