Problem with query expression when using a File geodatabase

WilsonIonara

I have a web map app with a search tool with one text input for company's name, one dropdown menu for county and two drop down menus for industry and industry type. I previously had my geodatabase in a SDE environment but after upgrading to ArcGIS Server 10.1, I decided to use a file geodatabase because it is easier. However my query expressionf for the company is not working properly anymore.

Here is the code snippet:

 var expr:String = "";   if (qText.text != "") {  // for the text with apostrophe be recognized on the query qText.text = qText.text.replace("'","''") expr = "Company Like '%" + qText.text + "%' AND Status_not = ' '" ;   } 

So, do you guys have any idea in how to make this work again with a file geodatabase?

If I search for "tem", it does not bring me the companies that start with "Tem" anymore, just the ones that have tem somewhere in their name. If I search for Caesar's or Cae, it does not bring me the company with that name, but if I search for aes, it will bring that company and others that have aes somewhere in their name. Thank you for any help!!!

rscheitlin

Ionara,

   Simply use this:

expr = "Upper(Company) Like Upper('%" + qText.text + "%') AND Status_not = ''" ;