Link to home
Start Free TrialLog in
Avatar of Motaz
Motaz

asked on

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
Avatar of kretzschmar
kretzschmar
Flag of Germany image

Hi Motaz,

what database do you use?

meikl
Hi again Motaz,

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

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

meikl
Avatar of Motaz
Motaz

ASKER

I use Pradox 7
ASKER CERTIFIED SOLUTION
Avatar of kretzschmar
kretzschmar
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Motaz

ASKER

Thanks meikl

Motaz