Text Search

From: Ibrahim Awwad ("Ibrahim)
Date: 10/03/04 

Date: Sun, 3 Oct 2004 01:35:02 -0700

Dear All,
   I have table for items, some of the Items codes are including text codes.
When I try to use
Select From **** Where **** like '****'

I don't get the correct record until I put the Upper case or lower case text
corrosponding to What's in table.
EX. to look for 'DISCOUNT' i can't give him 'discount' I should write it as
it's.

Is there any solution. 

-- 
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|-----------------------------|
|Islam is peace not Terror|
|-----------------------------|