Re: substrings in Field

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rick (rick_at_di-wave.com)
Date: 08/07/04 

Date: Fri, 6 Aug 2004 22:32:20 -0700

Thanks I will try that.

"Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
news:2ni1n1F14gfnU1@uni-berlin.de...
> You'd use an SQL statement with Like % in FoxPro
>
> SET PATH TO HOME(2) + "Northwind"
> SELECT * From customers WHERE companyname Like '%z%'
>
>
> -Stefan
>
> "Rick" <rick@di-wave.com> schrieb im Newsbeitrag
> news:%235tuCZ9eEHA.3412@TK2MSFTNGP11.phx.gbl...
> > If I want to search a substring of a field with VB6 for Access I use
Like *
> > or with SQL I use Like % how do I do that with FoxPro.
> >
> > Thanks for any help!!!
> >
> >
>