ssolberg
VIP Member
WW and \"LIKE\" in Data Selections
I swear I've done this before but now I can't seem to get it to work and hoping someone can verify for me. In my example, I am looking for any part # that ends in a "C". The selection would therefore be LIKE '%C' to accomplish this but it doesn't find anything. I used the LIKE operand using '%C%' (anything with a C in the field) as well as 'C%' (anything that starts with a C) and it find tons of stuff correctly. Yes, I am positive I have parts that end in a "C"... I am sure I have done this on (possibly) prior cumes of World and there is a SAR (3495766) that sort of touches on the LIKE operand but that is something fixed in cume 12. Can someone verify if '%something' works in some other cume level other than 11? Use your favorite file and field, it shouldn't matter...
Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, SP14.2 V4R5 (not happy)
I swear I've done this before but now I can't seem to get it to work and hoping someone can verify for me. In my example, I am looking for any part # that ends in a "C". The selection would therefore be LIKE '%C' to accomplish this but it doesn't find anything. I used the LIKE operand using '%C%' (anything with a C in the field) as well as 'C%' (anything that starts with a C) and it find tons of stuff correctly. Yes, I am positive I have parts that end in a "C"... I am sure I have done this on (possibly) prior cumes of World and there is a SAR (3495766) that sort of touches on the LIKE operand but that is something fixed in cume 12. Can someone verify if '%something' works in some other cume level other than 11? Use your favorite file and field, it shouldn't matter...
Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, SP14.2 V4R5 (not happy)