Paradox SQL Case Sensitivity

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)
LVL 1
flooderAsked:
Who is Participating?
 
IPCHConnect With a Mentor Commented:
The UPPER works with Paradox too.
Try this:

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

in demo database.
0
 
kretzschmarCommented:
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
 
flooderAuthor Commented:
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
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.

All Courses

From novice to tech pro — start learning today.