Valid SQL statements for query.text and query.where

[KennethRichards]

Can anyone give me a link to valid SQL statements that I can use when building my where and text queries?

[KaitlynnDavis · Accepted solution]

If you are familiar with "Select by Attributes" in ArcGIS for desktop, you use the same SQL syntax that you do for the query.where property in arcgis javascript

http://resources.arcgis.com/en/help/main/10.1/index.html#//00s500000033000000

Here is an example in legacy dojo:

var queryTask = new esri.tasks.QueryTask("URL to the resource to be queried");      var query = new esri.tasks.Query();      query.returnGeometry=false;      query.outFields = "*";      query.where = "YOUR_FIELD = 'the value to query' ";