Solved

Paradox SQL Case Sensitivity

Posted on 2000-05-18
3
471 Views
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)
0
Comment
Question by:flooder
3 Comments
 
LVL 27

Expert Comment

by:kretzschmar
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)

meikl
0
 
LVL 2

Accepted Solution

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

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

in demo database.
0
 
LVL 1

Author Comment

by:flooder
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.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

828 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