SQL Functions.
Constant | Value | Description |
---|---|---|
esriSQL_MIN | 1 | SQL MIN. |
esriSQL_MAX | 2 | SQL MAX. |
esriSQL_COUNT | 3 | SQL COUNT. |
esriSQL_SUM | 4 | SQL SUM. |
esriSQL_AVG | 5 | SQL AVG. |
esriSQL_VAR | 6 | SQL VAR. |
esriSQL_STDDEV | 7 | SQL Standard Deviation. |
esriSQL_CONCAT | 8 | SQL CONCAT. |
esriSQL_LEADING | 9 | SQL LEADING. |
esriSQL_LOWER | 10 | SQL LOWER. |
esriSQL_TRAILING | 11 | SQL TRAILING. |
esriSQL_SUBSTRING | 12 | SQL SUBSTRING. |
esriSQL_SUBSTRINGBYTES | 13 | SQL SUBSTRING Bytes. |
esriSQL_UPPER | 14 | SQL UPPER. |
esriSQL_ASCII | 15 | SQL ASCII. |
esriSQL_CHAR | 16 | SQL CHAR. |
esriSQL_SOUNDEX | 17 | SQL SOUNDEX. |
esriSQL_TRANSLATE | 18 | SQL TRANSLATE. |
esriSQL_TRIM | 19 | SQL TRIM. |
esriSQL_ABS | 20 | SQL ABS. |
esriSQL_ACOS | 21 | SQL ACOS. |
esriSQL_ASIN | 22 | SQL ASIN. |
esriSQL_ATAN | 23 | SQL ATAN. |
esriSQL_CEILING | 24 | SQL CEILING. |
esriSQL_COS | 25 | SQL COS. |
esriSQL_FLOOR | 26 | SQL FLOOR. |
esriSQL_LOG | 27 | SQL LOG. |
esriSQL_LN | 28 | SQL LN. |
esriSQL_MOD | 29 | SQL MOD. |
esriSQL_SIGN | 30 | SQL SIGN. |
esriSQL_SIN | 31 | SQL SIN. |
esriSQL_TAN | 32 | SQL TAN. |
esriSQL_LOG10 | 33 | SQL LOG10. |
esriSQL_POWER | 34 | SQL POWER. |
esriSQL_ROUND | 35 | SQL ROUND. |
esriSQL_TRUNCATE | 36 | SQL TRUNCATE. |
esriSQL_SINH | 37 | SQL SINH. |
esriSQL_COSH | 38 | SQL COSH. |
esriSQL_TANH | 39 | SQL TANH. |
esriSQL_HEX | 40 | SQL HEX. |
esriSQL_EXTRACT | 41 | SQL EXTRACT. |
esriSQL_BITLENGTH | 42 | SQL BITLENGTH. |
esriSQL_CHARLENGTH | 43 | SQL CHARLENGTH. |
esriSQL_OCTETLENGTH | 44 | SQL OCTETLENGTH. |
esriSQL_POSITION | 45 | SQL POSITION. |
esriSQL_CURRENTDATE | 46 | SQL CURRENTDATE. |
esriSQL_CURRENTTIME | 47 | SQL CURRENTTIME. |
esriSQL_CURRENTUSER | 48 | SQL CURRENTUSER. |
esriSQL_COALESCE | 49 | SQL COALESCE. |
esriSQL_CONVERT | 50 | SQL CONVERT. |
esriSQL_CAST | 51 | SQL CAST. |
Product Availability
Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.