Validation Rules: LIKE(text,pattern)

[Former Member]

Hello people.

I've a question.

Which wildcards can I use in pattern of LIKE function? I know only * (0..n). Iu2019m looking the wildcard for doing 1..n. For it, Iu2019m trying to use +, but it donu2019t works.

Could you help me?

Regards

[former_member202465]

Hi,

The LIKE() function is only to define a pattern to be matched against a given string.

For example -

=LIKE(@BANK_CTRY,"D*")

- returns true for @BANK_CTRY "DE" and false for "US".

I am under the impression that you are trying to do something that involves numbers, which LIKE() does not support.

Please correct me if I'm wrong,

Thanks,

Udi