Are there any plans for adding a string compa...

(John Gardner) #1

Are there any plans for adding a string compare function? Or is there one already that I don’t know about? Thanks

(Grant Stead) #2

What exactly do you mean?

(Dinh Nguyen Nguyen) #3

@John_Gardner You can use the “=” operator to compare string values. If this is not what you want, could you elaborate please?

(Aleksi Alkio) #4

How about CONTAINS?

(Steven Coile) #5

in() performs an exact, case-sensitive equality check. contains() and = are case-insensitive. contains() matches if operand 2 occurs anywhere in operand 1. = matches if either operand is blank!

Use in().

(John Gardner) #6

I am looking for a function that does more than “=”

Something more like a “<” or “>” but for strings.

(John Gardner) #7

It’s more about trying to sort strings than check for a string inside a string

(Grant Stead) #8

@John_Gardner taking about length of the string? Orderby and len