How to Cheat at IIS 7 Server Administration

Appendix C

Function Reference

In This Toolbox

Functions are powerful elements of the Log Parser SQL language; virtually all queries written with the Log Parser SQL language make use of at least one function. Functions take zero or more field-expressions as arguments, process their values, and return a new value. The Log Parser SQL language supports more than 80 functions, ranging from string manipulation functions (for example, SUBSTR, STRCAT) to arithmetical functions (for example, ADD, EXP).

Functions

The ADD function returns the sum of the two argument values.

When the arguments are of the STRING type, the value returned is the concatenation ...