Hi,
  I am searching for a query where i can have pattern matching without
considering the cases.You can consider the following example for detailed
description of what i want exactly.

   Let my table X consists of following data
    Name
-------------------
venu
venup
venugopla
VenugOpal
VENU
papasani
papasni
pvenu
      Now i need to get all the records which consists of the string
venu(case should not be considered either case should be).i.e i should get
1,2,3,4,5,8 records
     I will be very much thankful if any of you give me the query for this.

     Thanks in Advance,

Regards,
venu.
(sorry for my poor English)

Reply via email to