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

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

paschottpaschott Posts: 71 Bronze 4
edited February 22, 2008 6:49AM in SQL Prompt Previous Versions
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

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    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
    Principal Consultant
    bartread.com Ltd
  • Options
    paschottpaschott Posts: 71 Bronze 4
    Thanks, Bart. I missed that option. That should take care of that issue. Gotta love training problems. :)
  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    No problem, you're very welcome. :D
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.