What are the function buttons at the bottom of the Columns pane?
The function buttons at the bottom of the Columns pane are combo-boxes, which contain most of the SQL common functions that are often needed for the creation of a complex query. These functions are used in combination with ordered user-selected field-rows in the Columns pane. In particular, these functions include the following SQL functions: concatenation of field into strings, masking, aggregate functions (AVG, COUNT, MAX, MIN, SUM, STDEV, VAR), string functions (CHARINDEX, DIFFERENCE, LEFT, LEN, LOWER, LTRIM, PATINDEX, REPLACE, QUOTENAME, REPLICATE, LEFTPAD, RIGHTPAD, REVERSE, RIGHT, RTRIM, SOUNDEX, SPACE, STR, STUFF, SUBSTR, TRIM, UPPER), numeric functions (ABS, CEILING, FLOOR, ROUND, TRUNCATE, SIGN), date part and name functions (YEAR, QUARTER, MONTH, DAYOFYEAR, DAY, WEEK, WEEKDAY, HOUR, MINUTE, SECOND, MILLISECOND), conversion functions, and case functions.
