QueryUsingINOperator

    Table of contents
    No headers

     

    [City] = 'Whitehorse' And [City] = 'Dawson City' And [City] = 'Haines Junction' And [City] = 'Old Crow'

    ....which is pretty clunky and awkward.... you can change them to this:

    [City] IN ('Whitehorse', 'Dawson City', 'Haines Junction', 'Old Crow')

    ...much nicer. Read more about it here at ArcGIS Desktop Help:
    http://webhelp.esri.com/arcgisdesktop/9.1/index.cfm?TopicName=SQL%20reference

     


    thanks for the tip, that's much simpler!

     

     

     

     

    WebForm
    TopicCategory TipsAndTricks

     

     

        Send feedback