Page 1 of 1
In the list - Filter
Posted: Fri Oct 02, 2009 8:22 am
by dtester_(Guest)
If I am running a report against a sql 2005 database and want to use the "in the list" filter, how do I do that?____Example I would like to run a report that:__Item.Items in the list __TM%__TMF%____I have tried TM%, TM* and it comes back no records. But if I do Item.items is like TM% I get results.____Thank you____David Tester
=> RE: In the list - Filter
Posted: Fri Oct 02, 2009 9:59 am
by kfleming
You can use two like clauses as an alternative to using a single in the list.____Kathleen__R&R Support
=> RE: In the list - Filter
Posted: Mon Oct 05, 2009 12:09 pm
by Tom_Freitas_(Guest)
You can also use substring such as substr(field_name,1,2) = "TM" or substr(field_name,1,3) = "TMF"____Since it looks like you want only part of the string to be in the filter, the substring would be best. Of course you could use a substring in a CASE filter as well.____Tom Freitas