>All of these picked up the info on all of the companies. I've run into this problem before and have just done the following (which I can do again).
>
>Select < stuff I need > from < mytable >
>delete all for field1 = 'A' or field1 = 'B'
>
>I was just wondering if there was a way to get the results I want without doing the delete command.
>

Select < stuff I need > from < mytable > where ! field1 IN ('A','B')


>Thanks.