This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I need to exclude items from a list but I'n unable to find any way to use a NOT LIKE in the QueryExpression. I'm not using Linq the queryExpress is defined based on the users input. Kind regards, Johan |
|
|
|
|
a lightspeed NegatedExpression ? |
|
|
|
|
Negated would work I think but how would you OR them Eg. Name NOT LIKE '%John%' AND Name NOT LIKE '%Peter%' but all built up dynamically. When the normal Query express you can just do the following: Exp &= new Expression etc... But for the NegatedExpression it does not seem to work. Cheers |
|
|
|
|
I might be missing something here but would this not work for you?
|
|
|
|
