TABLE OF CONTENTS 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).
The ADD function returns the sum of the two argument values.
<b class="bold">ADD(addend1, addend2 )</b>
When the arguments are of the STRING type, the value returned is the concatenation of the strings.
<b class="bold">BIT_AND(argl, arg2 )</b><b class="bold">BIT_NOT(arg )</b><b class="bold">BIT_OR(argl , arg2 )</b><b class="bold">BIT_SHL(argl , arg2 )</b><b class="bold">BIT_SHR(argl , arg2 )</b><b class="bold">BIT_XOR(argl , arg2 )</b>
The BIT... functions calculate the specified bitwise operators on the argument values.
<b class="bold">CASE</b><b class="bold"> WHEN THEN </b><b class="bold"> [ ...]</b><b class="bold"> [ELSE ]</b><b class="bold">END</b>
The CASE function compares the value of the specified field-expression with the values of the field-expressions in the WHEN statements, returning the value of the field-expression specified in a THEN statement when a match is found. If no match is found, the value of the ELSE statement field-expression is returned, or NULL if no ELSE statement is provided.
<b class="bold">COALESCE(argl, arg2 [, . . . .])</b>
The COALESCE function returns the first non-NULL value found among the specified arguments. The following...
