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 venu--k venu-t 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 but i should not get 9 and 10th records which is also consists of venu. 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)