Subject: | Re: query case sensitive with wildcards
| Date: | Tue, 13 Apr 2021 21:13:29 -0800
| From: | Peter <peterspammenot@whiteknight.email>
| Newsgroups: | pnews.paradox-programming
|
From Dan Erhman's book "Paradox Queries", pg 76
"selection criteria are case-sensitive."
Unfortunately...
pg 115
"When you use the Paradox wildcards, the search is not case-senstive. If
you search for ..Tool.. in a field, Paradox will find a match even if
the word is spelled TOOL, tool, or ToOl. The search is relatively slow
because Paradox has to scan each record in the table to find the string
wherever it appears in the designated field. Paradox cannot use indesxes
for this kind of search."
At least You have your answer.
Peter
On 4/13/21 9:56 a.m., Kevin Zawicki wrote:
> I know I can do this in SQL (I think).
>
> Any way to run a query with wildcards:
>
> ...test..
>
>
> and make it case sensitive?
> no indexes on that column
>
|