Syntax Question - Not Like

[bigmelon]

How do you say the equivalent to Not Like in a formula? The formula i want is as follows:

if {Surgproc.Proc_Type} like '*rima*' and {Surgproc.Proc_Type} not like'*lima*' then "Right IMA" else ""

When I put the not in there is says the statement is missing the then statement but without it i have no errors.

Thanks in advance,
Jeremy

 

[vidru]

The Not comes before the entire condition:

if ({Surgproc.Proc_Type} like '*rima*') and not ({Surgproc.Proc_Type} like'*lima*') then
"Right IMA"
else
""

-dave

 

[bigmelon]

Thanks dave