I need a criteria expression to not include records that start wit
 

I have a list with some records that start with *. I would like to exclude
these from the list with a query. I have tried Not Like '~*%' but it does
not exclude the records. Does anyone have a suggestion for me.

I need a criteria expression to not include records that start wit
 

Hi Steve

use an auxiliar column with this formula

=if(lefet(a2,1)="*",mid(a2,2,255),a2)
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Steve A" escreveu:

I have a list with some records that start with *. I would like to exclude
these from the list with a query. I have tried Not Like '~*%' but it does
not exclude the records. Does anyone have a suggestion for me.

I need a criteria expression to not include records that start wit
 

Thanks for your help but I am trying to accomplish this with query so I don't
have to manipulate the table each time I re run the query.

"Steve A" wrote:

I have a list with some records that start with *. I would like to exclude
these from the list with a query. I have tried Not Like '~*%' but it does
not exclude the records. Does anyone have a suggestion for me.