Convert to UPPER - AutoCompleteBox

Permanently deleted user

August 29, 2014 22:37

Can anyone help with what I believe should be a simple query,

I want to convert the LA County ParcelID search to UPPER case to match my needs.

Here is the where clause in the form: {0} Like '{1}%'

Any help would be much appreciated.

 

 

0

• 

  Permanently deleted user

  August 29, 2014 23:05

  Hi Chris,

  I'm not a pro at this, but I think if you add UPPER a couple of times it will do the trick:

  UPPER{0} Like UPPER'{1}%'

  Give that a shot.  My query is a bit insane in comparison but this is what I am using, in case it helps:

  "UPPER (NAME) LIKE UPPER('" + "%" + name + "%" + "')"

  Cheers,

  Stephanie

  0
• 

  Permanently deleted user

  August 30, 2014 00:25

  Thanks for the help,

  That didn't seem to do it, the query looks right but anytime I change what I currently have the autocomplete box no long works.

  Chris

  0
• 

  Permanently deleted user

  August 30, 2014 02:19

  Just wanted to say thanks! I played around with what you sent and this is what eventually worked.

  {0} Like UPPER ('{1}%')

   

  Chris

   

  0
• 

  Permanently deleted user

  August 30, 2014 05:44

  awesome!  :)

  0
• 

  Permanently deleted user

  September 02, 2014 20:38

  Has anyone else noticed a severe performance hit when using Upper() as opposed to having the user type the contents in uppercase?

  0
• 

  Permanently deleted user

  September 02, 2014 20:49

  I have not noticed a performance hit since I got it working no, the auto-complete appears almost instantly.

   

  Chris

  0

Please sign in to leave a comment.