How can we help you today? How can we help you today?

Can you make the seach be case sensitive

My issue is I am not sure how to have the search string return results based on case sensitive results.

Example: If I want to search the Keyword “VAT”. Currently my search result, without the “Mathc whole words only” unchecked,  will return objects containing:

VAT_Rate, Group_VAT, activated, deactivated, reactivated

Patrick Ortuso
0

Comments

1 comment

Sort by
  • Christian Perez
    Official comment

    Hi Patrick,

    Thanks for reaching out to Redgate Support with your SQL Search inquiry. Unfortunately SQL Search does not use case sensitivity in its search results. This means that when you search for a term like “VAT”, SQL Search will return any result containing those letters in any casing, regardless of where the letters appear in the word. For example, this can include objects like VAT_Rate, Group_VAT, but also words such as activated, deactivated, and reactivated, because the tool matches the substring “vat” without considering case.

    Currently the ‘Match whole words only’ option will be the best manner to restrict search results to only direct matches of the substring VAT, however, Redgate has received customer feedback requesting true case‑sensitive searching, and this has been logged as a feature suggestion for potential future improvement.

    Let me know if you have any remaining questions.

    Christian Perez

    Product Support Engineer

    Christian Perez

Add comment

Please sign in to leave a comment.