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
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
I will be very much thankful if any of you give me the query for this.
Thanks in Advance,
(sorry for my poor English)