How can we improve Azure Search?

Support case-insensitive comparison in filters

Searching with text=<xyz> performs a case-insensitive search. However, testing string fields in filters is case-sensitive. There should be a way to do a case-insensitive string comparison in filter expressions.

688 votes
Vote
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
You have left! (?) (thinking…)
Bruce Johnston - MSFT shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

16 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
An error occurred while saving the comment
  • arild røksund commented  ·   ·  Flag as inappropriate

    What time can we expect an answer to this case? I can see that the suggestion have been "under review" since September 2014, close to 5 years...

  • Haotian Sun commented  ·   ·  Flag as inappropriate

    We also need this feature. Seems it's a common requirement and would like to see an option there to enable case-insensitive match.

  • Anonymous commented  ·   ·  Flag as inappropriate

    This seems like an essential option for any DB. I can't imagine it would be that expensive to implement on Microsoft's end either.

  • Peter Liu commented  ·   ·  Flag as inappropriate

    We also need this feature badly...

    We moved our data from SQL to Azure Search. In SQL, it is case insensitive comparison. To maintain the same capability, we need to be able to filter using case insensitive comparison.

  • Nagi Reddy Gatla commented  ·   ·  Flag as inappropriate

    We need this feature very badly, as to do case in-sensitive search, we are using upper function in queries but it is slowing down the query performance a lot, releasing this feature soon will help us immensely. Thanks!

  • vartika commented  ·   ·  Flag as inappropriate

    is the case insensitive search can work with wildcard search (startswith, endswith or contains). this is the essential feature i need.

  • Anonymous commented  ·   ·  Flag as inappropriate

    please provide an option to search with or without case sensitive by providing a querystring

Feedback and Knowledge Base