dick scherrer wrote:Hello,
From what you have posted, i do not understand what you want your query to do.
Please do a more complete job showing what you "have" as input in the table(s) / rows(s) and what you want returned when the query runs correctly.
Use the Code Tag to preserve alignment and improve readability. Practice using the Preview function before Submitting.
My Input file(test) is this:
FILD1 |FIELD2
------- ---------------------------------
XXXX |'AB' OR 'CD' OR 'EF'
YYYY |'GH' OR 'IJ'
ZZZZ |'KL' OR 'AB'
-------------------------------------------
Query I written :
SELECT FILD1
FROM TEST
WHERE FIELD2 LIKE '%AB%' OR 'AB%'.
Code'dWill this query give Output XXXX and ZZZZ? This is my assignment. Dont have any Mainframe IDs to test. Once I get approval only . I can proceed further.
Sorry dick Even if i have given spaces also, It s coming lik that only.