Paradox SQL Case Sensitivity

Posted on 2000-05-18
Medium Priority
Last Modified: 2010-05-18
I want to search for example for the following in a string field independant of case
Blue Green Data
blue Yellow Orange
Computer Blue Data

if i search for blue 'where field1 like '%blue%' I only get one match because of the case how can i get all three matches(Searching case independant)
Question by:flooder
LVL 27

Expert Comment

ID: 2820240
hi flooder,

well not tested on paradox but its local sql, maybe it works

Select name from phone where upper(name) like upper(:ComapareValue)||'%'

(rebuild it to your needs)


Accepted Solution

IPCH earned 120 total points
ID: 2820321
The UPPER works with Paradox too.
Try this:

Select * from Customer where UPPER(Company) like '%C%'

in demo database.

Author Comment

ID: 2825084
It works great thanks.

Last thought what book would be recommended to buy on SQL for delphi or does it depend on the database and if what book on general SQL is good to buy.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question