Usersettings not recognised as text?

AppSheet AppSheet Q&A
1

Why this expression returns false: CONTAINS([Adresse],(USERSETTINGS(“Rue”))?

While this one returns TRUE: CONTAINS([Adresse],“Marie”)?

For the following values:

USERSETTINGS(“Rue”) = Marie

[Adresse]= 27 RUE MARIE-CECILE

2

May I ask where do you use it?