Wildcard character percent in DB2

Wildcard character % in DB2 If you wish to fetch a row from a DB2 table and you do not know what is the exact value in a column then you can use wild card character % (percent wild card character) Wild card character % can be used as a substitue for n number of charachters. For example you are looking for employees whos first name begins with JA then you can write the following query ; ; ; ;

SELECT * FROM EMP_TABLE WHERE FNAME LIKE ‘JA%’