Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Java Programmer 2
Sign in to Add to Watch List

IT & Programming > Software Application

View Change History

The client has made the following changes to the job.


Bidding period ended early.

Apr 2, 2012

Job awarded.

Mar 31, 2012

Job Description

  |  Change History >>


  • Posted: Sat, Mar 31, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Many databases allow case-insensitive pattern matching expression ILIKE, like

string ILIKE pattern
string NOT ILIKE pattern

Some databases, like MySQL, only has the case-sensitive expression LIKE, but does not support ILIKE.

You need to write a function in Java that will take a SQL statement as input and convert all ILIKE expressions into equivalent expressions with LIKE. Output will be something like:

UPPER(string) LIKE UPPER(pattern)

Here both string and pattern could be any string expression.

Please note that SQL keywords like ILIKE, LIKE, NOT, UPPER, etc are not case sensitive. I'm using capitalized forms for highlighting.

Sign in or Register to see more

Desired Skills
Job ID: 29608988
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Mikhail B.      
Mikhail B.'s identity has been verified.  Learn More
 Russia  |  
Professional programmer, 12 years experience. C++/C#/Java/Perl iPhone/iPad/Blackberry I prefer backends, services, network protocols, small Windows...
Skills: C#, Java, C++, Qt, C, .NET Framework, Perl, SQL, JSP
 4.9   |  $38,389 Earnings   |  24 Jobs   |  1 verified credential(s)
Bid ID: 29609161  |  Submitted: Mar 31, 2012 13:46 ET 
Within 3 days
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »