Question Opposite to MATCHES

[Haso KEric]

How can i do NOT MATCHES... when i put the NOT infront of it i get a Error... What other way is there to accomplish this?

 

[medu]

not <string> matches <pattern>

 

[Haso KEric]

ProdGrup.Description NOT "House" MATCHES '*House*'

?

Invalid query: where Company = 'DIEN' and (ProdGrup.Description NOT 'House' MATCHES '*').

 

[jdpjamesp]

where Company = 'DIEN' and NOT ProdGrup.Description MATCHES '*'.

 

[Haso KEric]

Thank you to all of you, works wonderful