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. |
| esriSQL_CURRENTTIMESTAMP | 52 | SQL CURRENTTIMESTAMP. |
| esriSQL_NULLIF | 53 | SQL NULLIF. |
| esriSQL_VAR_SAMP | 54 | SQL VAR_SAMP. |
| esriSQL_VAR_POP | 55 | SQL VAR_POP. |
| esriSQL_STDDEV_SAMP | 56 | SQL STDDEV_SAMP. |
| esriSQL_STDDEV_POP | 57 | SQL STDDEV_POP. |
Product Availability
Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.