This document is archived and information here might be outdated.  Recommended version.


esriSQLFunctionName Constants (ArcObjects .NET 10.4 SDK)
ArcObjects Library Reference (GeoDatabase)  

esriSQLFunctionName Constants

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.