i need to find if a field has a single lower letter. For example: "HOUsE", i want something that says to me "This word has a lower letter". Can't use the function lower or upper because they change all letters in a word.
I have tried if(wildmatch(FIELD, '*a*', '*b*',...) ,1,0) as check but it find upper letters too and not only lower.
Hi I don't know about singe lower letter , but If you are looking for an expression to see if there is any amount of lower letters in a word This will do the trick :
In the below expression the Field is call Word.
if(upper(Word)<>Word,'there is a lower letter in the word','No lower letters found')
Hi I don't know about singe lower letter , but If you are looking for an expression to see if there is any amount of lower letters in a word This will do the trick :
In the below expression the Field is call Word.
if(upper(Word)<>Word,'there is a lower letter in the word','No lower letters found')
