Your Database was created with 'case sensitive' option. To change to 'case
insensitive', you must re-created the Database, I think.
Also, you can try:
Select From **** Where upper(****) like upper('****')
[quoted text, click to view] "Ibrahim Awwad" wrote:
> 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|