Ignoring case in query

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
LVL 7
MotazAsked:
Who is Participating?
 
kretzschmarCommented:
Hi Motaz,

This works in paradox also :

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

meikl
0
 
kretzschmarCommented:
Hi Motaz,

what database do you use?

meikl
0
 
kretzschmarCommented:
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
 
MotazAuthor Commented:
I use Pradox 7
0
 
MotazAuthor Commented:
Thanks meikl

Motaz

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.