What are the challenges you face when working across database platforms? Take the survey
Options

How do I search for exactly my search phrase

FwebbFwebb Posts: 1 New member
I am searching for GA PICKING and only want that result returned. I am getting GA, PICKING, not just "GA PICKING"
Tagged:

Answers

  • Options
    Hi @Fwebb

    Thank you for reaching out on the Redgate forums.

    Regarding your SQL Seach query - the best method is to enable the 'Match whole words only' when searching for multi-word phrases.

    However as you are finding, the comma (,) is ignored. My understanding behind this behavior is that it is connected to how the text is parsed using comma-separated values. So when the , is ignored GA, PICKING & GA PICKING are both going to hit as a match in your search results.

    If this is a major concern on your usage of SQL Search I may suggest posting a feature request on our UserVoice page. This page allows users of Redgate software to highlight features or functions that can enhance our software to be better usable. 
    For SQL Search the UserVoice link is https://redgate.uservoice.com/forums/101149-sql-search

    Jon Kirkwood | Technical Support Engineer | Redgate Software
Sign In or Register to comment.