By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,018 Members | 930 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,018 IT Pros & Developers. It's quick & easy.

DB2 - Problem with using LIKE predicate

P: 1
Hi - I have a query like this:

Expand|Select|Wrap|Line Numbers
  1. REPORT_TYPES LIKE '%ABC - '||(SELECT RES.RESOURCE_TYPE FROM TBL_REPORT REPT, TBL_RESOURCE_REQUEST RES WHERE REPT.REPORT_ID = ' ' AND REPT.STATUS = 'A' AND RES.RESOURCE_REQUEST_ID = REPT.GLOBAL_REPORT_ID)||'%'
This query is failing bcos of the select query being used in the operand of the LIKE predicate.

Anyone have an idea how to workaround this?

Thanks,
Maitreyi
Nov 19 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.