Filter Expression Help

[gatorfe]

I am trying to create a filter were I can exclude certain products from showing on my report.  The products all end in "LLL". Any suggestions would be greatly appreciated.  Thanks

[whastings]

when defining a filter, one of the available Operator Functions (e.g. =, <>, etc.) is "ends with", so you should be able to say "not ends with".

[admin_cog]

can you try using substr..

[Gopinath]

try a filter expression like

[Products] Like '%LLL'

[kerryn]

He wants to exclude so use [field] not like '%LLL' assuming the database is oracle of course.