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

[FR?] Columns in table take precedence over functions?

Another issue I run into often. We have a couple of tables that have "Is_Enabled" or "Is_Active" or similar as column names. When I start to type out to get down to that area, the "IS" operator jumps ahead of my column name. Minor, but it is a little irritating, especially as the "IS" appears below the column until I filter down to just that small list.

-Pete
paschott
0

Comments

3 comments

Sort by
  • Bart Read
    Hi Pete,


    Go to SQL Prompt > Options on the main menu bar in SSMS/QA or whatever editor you use. Now go to Listed Candidates > Candidate Ordering. If you uncheck "Display exact matches at the top of the candidate list" you'll find that IS doesn't get pulled to the top of the list in this situation.

    Hope that helps.


    Thanks,
    Bart
    Bart Read
    0
  • paschott
    Thanks, Bart. I missed that option. That should take care of that issue. Gotta love training problems. :)
    paschott
    0
  • Bart Read
    No problem, you're very welcome. :D
    Bart Read
    0

Add comment

Please sign in to leave a comment.