Retrieve substring through Query

  • Thread starter Thread starter ACG
  • Start date Start date
A

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!
 
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
 
Back
Top