Subject: | Re: query case sensitive with wildcards
| Date: | Wed, 14 Apr 2021 09:22:31 +1000
| From: | Leslie <"ViaThe List"@NOSPAM.com>
| Newsgroups: | pnews.paradox-programming
|
SQL is case sensitive by default
so use
where field like %test%
On 14/04/2021 2:56 AM, 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
>
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
|