Wildcard character _ in DB2 Wild card character _ (underscore) is used to substitute exactly one character in a DB2 query. If you wish to fetch data from a DB2 table and you do not know what is the exact value in the column but you remember all the chars except one character somewhere in the value then you can use wild card character For example you are looking for employees whos first name is either JOLT or KOLT then you can use the following ; ; ; ;
SELECT * FROM EMP_TABLE WHERE FNAME LIKE ‘_OLT’
The above query will list down all the employees whose name starts with any char followed by “OLT”