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