I have a form field filter. The two options only are Male or Female. A query for Female produces expected results but when query for Male the Female records are also captured.

How can I solve this? Is a case sensitive filter option available? Or any other solution ?

Regards

Ian Gonsal

Hello, just use '=' filter, instead of 'contains'.

Thanks Teodor