Retrieve substring through Query

[ACG]

Hi
I have a VB and S access application. In the database, there is a filed of
type memo. It contains long text, out of which I want to
retrieve a part, using the SQL statement in my VB to get recordsets.
Suppose the data in the memo field contains a name in single quotes, which I
wanna retrieve. I understand that the string functions can be
used in a query also, can anyone give me the format?
Thanks!

 

[Rick Bean]

ACG,
Because you've sent this to a group of newsgroups, I have to ask if you really want the syntax in VFP or VB?

Rick