I have a table that may have any where from 1000 records to 20,000 recirds in it on a daily basis. I have to set up a process to get some data out into another table. I have done this a thousand times. This is what I do:


SCAN

DO CASE

CASE LEN(alltrim(newtranrt)) != 9

SCATTER MEMVAR
INSERT INTO collections FROM MEMVAR
USE IN collections
SELECT risdata_temp
DELETE NEXT 1

CASE ALLTRIM(newtranrt) = '999999999'

SCATTER MEMVAR
INSERT INTO collections FROM MEMVAR
USE IN collections
SELECT risdata_temp
DELETE NEXT 1
endscan


This is really longer but I dind't want to bore you.

I have a situation where I need to look at a part of a field. The field wil contain something like "MERCH FEES", or "FEE" or "BANK FEE." They all contain the word "FEE" in it somewhere. I am not sure how to do something like this and it work properly:


CASE amount<= 50.00 and NOT EMPTY(newmid) and ENTRYDESCR='FEE'

I am thinking this will fail because of the ENTRYDESCR='FEE' part. The field will really have the whole phrase in it. This works fine with a "SEEK" though.

Any ideas?

Thanks for your help in advance.