Hi All,
I have a report that accepts multiple values from a TEXT BOX Prompt.
For example user entered values can be like:
bhn76999654
gh67835179o
AN638672ybv
Requirement is to match only the seven characters from the third character of the above given values to a field in a table.
So, my where clause should be like:
table.field IN (substr(bhn76999654,3,7), substr(gh67835179o,3,7), substr(AN638672ybv,3,7))
I am using oracle 12c and Cognos 10.2.1
Appreciate your help!