I wonder if
where LIKE '%932% would be too slow ?

----- Original Message -----
From: "robert.gilland" <robert.gilland@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, August 18, 2009 5:13 PM
Subject: Re: [IBO] Full Text Search and Numbers


> --- In IBObjects@yahoogroups.com, "Hans" <hhoogstraat@...> wrote:
>>
>> Do you have an example ?
>>
>
> I have already established with Jason that Full Text Search is not capable
> of search lists of codes ie.
>
> BARCODE
>
> 09938383908283
> 88388237898239
> 38472387823723
> 73924983478932
>
>
> User then types in "932"
> the search should return the bottom code.
>
> However because of the way Full Text Search works it treats codes
> differently to actual words.
>
>
> Kind Regards,
>
> Robert.
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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 !
> Yahoo! Groups Links
>
>
>
>