January 28th, 2010, 04:41 PM
DB2 LIKE operator
I am new to this forums and new to DB2 too.
I need some help regarding the LIKE operator in DB2.
Here is my requirement.
I have a table that has values like:
I am supposed to write a query that looks for '1234' and return these values:
Any help is greatly appreciated.
January 30th, 2010, 07:21 AM
SELECT COL1 FROM MYTABLE WHERE
COL1 LIKE '%1234%' AND
COL1 NOT LIKE '%5%'
November 29th, 2013, 08:18 AM
Need Help to execute DB2 query containing LIKE operator in shell script
How the DB2 query can be included in shell script with LIKE ??