ArcGIS Developer Help

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.