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
Select * from phone where name like 'motaz%';
I want this query select records like 'Motaz', 'MOTAZ' and 'motaz'
I use TQuery in Delphi 3
Hi again Motaz,
if your Database Oracle or Interbase then you can use this:
Select * from phone where upper(name) like upper('motaz%')
meikl
if your Database Oracle or Interbase then you can use this:
Select * from phone where upper(name) like upper('motaz%')
meikl
ASKER
I use Pradox 7
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks meikl
Motaz
Motaz
what database do you use?
meikl