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

Inconsistent results for Exact Match

So I have a search I ran for a field name, and I have one stored procedure that gets returned twice without exact match - once as a text match and once as a column match. When I check 'Exact Match', the column match goes away.

Since the column match (if I understand the terminology correctly) is the value I'm searching for, and the text match is the variable name (with the leading @ symbol) I would almost expect the text match to disappear, since 'value' does not exactly match '@value', but my bigger concern is that I don't understand why the column match is disappearing. I even did a copy and paste of the column name in the query to be sure I had the formatting correct. I can confirm that the actual field definition matches the case of the query text and the search value.

I'm running SSMS 2008 against a SQL 2005 database with SP 2.
rreitz
0

Comments

2 comments

Sort by
  • rreitz
    FYI... I was thinking that if the query display only highlighted the matched values - column or text - or if it did column and text highlights in different colors, it might help be better understand why the columns disappear on exact matching... right now, both results have the exact same highlighting.
    rreitz
    0
  • Robbie Thng
    Thanks for your feedback!

    The behaviour of exact search is something we need to look at for the next release, I've taken a note of your comments.
    Robbie Thng
    0

Add comment

Please sign in to leave a comment.