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

paschott

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

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

paschott

Thanks, Bart. I missed that option. That should take care of that issue. Gotta love training problems.

Bart Read

No problem, you're very welcome.