| Subject | Re: [IBO] Searching for a string into a string |
|---|---|
| Author | Lucas Franzen |
| Post date | 2002-09-12T08:39:11Z |
Helen Borrie schrieb:
forgive me, but containing is always case insensitive, so:
WHERE MyStringField CONTAINING 'stre'
will find any STREET, street, StReEt, sTREEt, ...
Luc.
>Helen,
> At 09:33 AM 12-09-02 +0200, you wrote:
> >Hi all,
> >how can I let my customer search in a specified field for any string
> >within a string
> >
> >eg : he want to search for 'stre' in the streetname of an address, he
> >selects the column with the streets en the program must return all the
> >record who meets the searchcriteria
> > ==> Waterstreet
> > ==> street of george
> > ==> ...
> >
> >Thanks for the answer
>
> WHERE MyStringField CONTAINING 'stre'
>
> or, if you want it to be case-insensitive:
>
> WHERE UPPER(MyStringField) CONTAINING 'STRE'
forgive me, but containing is always case insensitive, so:
WHERE MyStringField CONTAINING 'stre'
will find any STREET, street, StReEt, sTREEt, ...
Luc.