Paradox Community

Items in pnews.paradox-programming

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
> 


Copyright © 2004 thedbcommunity.com