Query using like

ranjith_gowdhaman · New User Joined: 14 Dec 2005 Posts: 4 Location: india

The below query retrieve all strings that begin with the character sequence '%_\'

SELECT COL1 FROM TABLE WHERE COL1 LIKE '\%\_\\%' ESCAPE '\'

Can anyone shower light on the logic behind the query.

dick scherrer · Posted: Fri Feb 12, 2010 2:56 am

Hello,

Look here:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/2.22.7

If you read something in this manual that is not clear, post what you found and your doubt about it. SOmeone will be able to clarify.