Subject Fw: [IBO] Searching for a string into a string
Author Tiago Teixeira Barrionuevo
Then you can use LIKE:

WHERE MyStringField LIKE '%stre%'


WHERE MyStringField LIKE '%STRe%'

and so on.

----- Original Message -----
From: Lucas Franzen
Sent: Thursday, September 12, 2002 5:39 AM
Subject: Re: [IBO] Searching for a string into a string

Helen Borrie schrieb:
> 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:


forgive me, but containing is always case insensitive, so:

WHERE MyStringField CONTAINING 'stre'

will find any STREET, street, StReEt, sTREEt, ...


Yahoo! Groups Sponsor

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]