In the list - Filter

[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

[kfleming]

You can use two like clauses as an alternative to using a single in the list.____Kathleen__R&R Support

[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