case sensitive word search

[craigja]

I have a list of words or in some cases abbreviations and Im looking to filter titles that contain these words in them.  Im sure Im missing something here but I cant get it to work.....  The problem I have found is if I filter for contains ([field}, 'UN') then when one of the titles is 'UK JMLSG Money Laundering Guide' it is filtered as Laundering contains un (Lowercase). Is there a way to make the contains command case sensitive?

I have 15 different words/abbreviations i want to filter out so I have got them all separated out with OR statements between them.

Craig

[patrick_digan · Accepted solution]

@craigja you can use contains ([field}, 'UN',0) to make it case sensitive

[craigja]

Perfect!  Never knew that was an option on Contains but now I look it is documented, thanks