Uppercase and lowercase functions?

Follow

Sagan Sidhu

• March 04, 2013 22:36

So I have a field, and the values can be:

xyz, XYZ, Xyz, XYz, etc, and so on.

 

Is there a way I can do something like:

(UPPER(field) matches "XYZ"), so that I dont have to try and match all combinations?

2

• 

  Kevin Keech

  • March 07, 2013 23:35

  We don't currently have this function but this is a great request and something we have been looking at implementing. Check back in a few weeks and hopefully we will have something for you then.

  0

  Comment actions Permalink
• 

  Josh Brown

  • November 21, 2013 07:02

  This would be great!  

  0

  Comment actions Permalink
• 

  Kevin Keech

  • June 26, 2014 03:04

  Operators to convert a string to upper or lower case has been delivered with the June 14, 2014 release. More information on these operators can be found here.

  0

  Comment actions Permalink
• 

  Josh Brown

  • June 26, 2014 03:11

  Nice!

  0

  Comment actions Permalink

Please sign in to leave a comment.