I have a table with a list of customers and a bunch of fields with
various info. One of the fields is a memo field used to log notes for
the sales people (when they open the memo field it automatically
inputs the date and their initials) and they just type in and save
their comments.

I want to extract out all the customers where the memo field contains
"JB" - so I can see which clients a sales person has been loging calls
for. The unique fields is the customer code (CCODE) and I want to do
something like select * from tablename where salesmemo contains
"JB"...... but do not think this is right

I am not a programmer and get a bit confused with syntax so go gently
with me!!!

thanks....

Hello, Alexandra!
You wrote on 25 Sep 2003 06:30:27 -0700:

A> I want to extract out all the customers where the memo field contains
A> "JB" - so I can see which clients a sales person has been loging calls
A> for. The unique fields is the customer code (CCODE) and I want to do
A> something like select * from tablename where salesmemo contains
A> "JB"...... but do not think this is right

A> I am not a programmer and get a bit confused with syntax so go gently
A> with me!!!

SELECT * ;
FROM tablename ;
WHERE "JB" $ UPPER(salesmemo) ;
INTO whatever

Note that filtering memo fields can be slow if you're querying against a
large table.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8