Then you can use LIKE:


WHERE MyStringField LIKE '%stre%'

or


WHERE MyStringField LIKE '%STRe%'


and so on.

----- Original Message -----
From: Lucas Franzen
To: IBObjects@yahoogroups.com
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:
>
> WHERE UPPER(MyStringField) CONTAINING 'STRE'

Helen,

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

WHERE MyStringField CONTAINING 'stre'

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

Luc.

Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - 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]