I've forgotten how to do a wildcard search using a table filter.

I've tried Filter := 'mymemo='''*Pepsi*''';
but that doesn't work because it returns no rows.

It will find "Pepsi" using

Filter := 'mymemo='''Pepsi*''';

only if mymemo starts with "Pepsi". So how can I search for a word or phrase that is
inside a text or memo column using a table?

TIA

Brent,

<< I've forgotten how to do a wildcard search using a table filter.

I've tried Filter := 'mymemo='''*Pepsi*''';
but that doesn't work because it returns no rows. >>

Use the LIKE syntax instead:

MyMemo LIKE '%Pepsi%'

--
Tim Young
Elevate Software
www.elevatesoft.com

Brent


Just like in sql - use LIKE eg Filter := 'mymemo LIKE ''pepsi'''

Roy Lambert [Team Elevate]

Blast forgot the %s

Roy Lambert

Roy Lambert wrote:

Blast forgot the %s

Roy Lambert

Roy & Tim,
     Ahh yes, the light went on.
Is there any way to make this filter case insensitive? The CaseInsensitive option doesn't
seem to do anything, at least not in DSU.

Brent

"Brent" <bdgridly@mailbolt.com> wrote in message
news:C7AE383F-3467-4EFE-8B27-20F2112F975B@news.elevatesoft.com...
> Is there any way to make this filter case insensitive? The CaseInsensitive
> option doesn't
> seem to do anything, at least not in DSU.
>
>
FilterOptions := FilterOptions + [foCaseInsensitive];

Rita

"Rita" wrote:

FilterOptions := FilterOptions + [foCaseInsensitive];

Hi Rita,
  That doesn't seem to work with a filter that is using "like". You can try it with the
DBSU program, but it doesn't work there either. If you can get it to work there, let me
know and I'll see if I can replicate it here.

Brent

Brent


Again think SQL

UPPER(MyMemo) LIKE UPPER('%Pepsi%')

Roy Lambert

Roy Lambert wrote:

Brent


Again think SQL

UPPER(MyMemo) LIKE UPPER('%Pepsi%')


Roy,
   Thanks.  Do you know if these table filter functions are available in all table
engines like BDE, Advantage, NexusDb etc.. or just DBISAM?

Brent

Brent


From memory definitely not in BDE other engines I can't say since I've been a DBISAM and now ElevateDB user since switching from the BDE.

Roy Lambert