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)
