Views with filter "Does not contain"

[cjbrown815]

Hi, I have a multiple line field I want to filter on that contains "Closed" when an item is closed, I want to filter on "Does not contain closed" (to show whats open) but there does not appear to be a way of doing this, any ideas? SharePoint is telling me I can only use "Contains" for multi-line fields. Are there wildcards or some kind of work around? thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[Qik3Coder]

If it is letting you use the CONTAINS (because I couldn't get a function to work with CONTAINS), then create a column that is a YES/NO with whether or not the field has closed in it, then just show the NO's.

Lodlaiden

You've got questions and source code. We want both!
Here at tek tips, we provide a hand up, not a hand out.