List:General Discussion« Previous MessageNext Message »
From:VenuGopal Papasani Date:March 13 2006 3:32pm
Subject:Help regarding a simple query
View as plain text  
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)

Thread
Help regarding a simple queryVenuGopal Papasani13 Mar
  • RE: Help regarding a simple queryJeff13 Mar
  • Re: Help regarding a simple queryPeter Brawley13 Mar
RE: Help regarding a simple queryJeff13 Mar