• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

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)
0
flooder
Asked:
flooder
1 Solution
 
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
 
IPCHCommented:
The UPPER works with Paradox too.
Try this:

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

in demo database.
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now