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%'