need to use a negative LIKE statement

[progers]

Hi everyone:

In the past I've used LIKE statements in my selection formulas. For example,

{Clinical_Transaction.proc_code} like '???DREVIEW'

Now I need to do the opposite. I have tried the following:

{Clinical_Transaction.proc_code} not like '???DREVIEW'

{Clinical_Transaction.proc_code} <> like '???DREVIEW'

In one case, CR tells me I'm missing a ). In the other case, it tells me i need a boulean or some such.

Any ideas?

Thanks,
Paul

 

[Ngolem]

I suppose you could try this:

Not({Clinical_Transaction.proc_code} like &quot;???DREVIEW&quot

Hope this helps
Jim

 

[progers]

That did it!!! Excellent. Thanks Jim.