Is there a way to set default values in the 'Select By Attribute' SQL editor (the where clause) ?

I want to set a permanent value that will appear every time I enter the 'Select by Attribute' window, like in this pic: alt text

It doesn't matter to me if it'll appear in all layers that will be selected or only in specific ones.

Oh, and I'm using ArcGIS 9.3.1.

Thanks in advance.

3 Answers 3


Why not just put a definition query on that layer?


I think it works as designed. each time you select a new field (even in the same session) the previous query is cleared. best bet is to keep a notepad with favorite queries, and paste those in as you neeed them. there is no need to do anything but paste it into the window and apply. not much but that is my workaround :-)


I am not aware of a non-programming way to do this, but you can use the Save and Load buttons at the bottom of the Select by Attributes window to save queries. I use this functionality for big queries that take some thought to build, but that I do not use very often, and therefore might forget before I need them again. If it is something that I need to do more than twenty times a day, I write a macro and assign it to one of the F* keys.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.