Using the LIKE operator in a filter
Hello,
I have a need to use the LIKE operator in some of my filters. However, on my
host database (DB2/400) the 'wildcard character' is a '%' (percent sign).
So, on the search tab, I supply the value %yyy% (hoping to match XXXyyyZZZ).
This results in no records being returned. Upon further investigation, I
determined that the generated SQL has WHERE FIELD LIKE '%yyy%*' (note the
added asterisk). It's nice of ReportBuilder to "help me out" like this, but
is there anyway to tell RB not to add the asterisk? If there's not some
setting change I could make, could you point me to the necessary location(s)
in the source that would require a change?
Thanks a lot!
Jef Duncan
I have a need to use the LIKE operator in some of my filters. However, on my
host database (DB2/400) the 'wildcard character' is a '%' (percent sign).
So, on the search tab, I supply the value %yyy% (hoping to match XXXyyyZZZ).
This results in no records being returned. Upon further investigation, I
determined that the generated SQL has WHERE FIELD LIKE '%yyy%*' (note the
added asterisk). It's nice of ReportBuilder to "help me out" like this, but
is there anyway to tell RB not to add the asterisk? If there's not some
setting change I could make, could you point me to the necessary location(s)
in the source that would require a change?
Thanks a lot!
Jef Duncan
This discussion has been closed.