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)
