?
Solved

Ignoring case in query

Posted on 1999-01-13
5
Medium Priority
?
217 Views
Last Modified: 2010-04-06
I want to ignor case in query for example :

Select * from phone where name like 'motaz%';

I want this query select records like 'Motaz', 'MOTAZ' and 'motaz'

I use TQuery in Delphi 3
0
Comment
Question by:Motaz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 1356329
Hi Motaz,

what database do you use?

meikl
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 1356330
Hi again Motaz,

if your Database Oracle or Interbase then you can use this:

Select * from phone where upper(name) like upper('motaz%')

meikl
0
 
LVL 7

Author Comment

by:Motaz
ID: 1356331
I use Pradox 7
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 40 total points
ID: 1356332
Hi Motaz,

This works in paradox also :

     Select * from phone where upper(name) like upper('motaz%')

meikl
0
 
LVL 7

Author Comment

by:Motaz
ID: 1356333
Thanks meikl

Motaz

0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

752 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