Caspio Bridge Function Reference
Math Functions
| Name | Parameters | Example | Description |
| Abs | (number) | Abs(-12) | Returns the absolute value of a number. |
| Acos | (number) | Acos(0.123) | Returns the arccosine of a number in radians. |
| Asin | (number) | Asin(0.123) | Returns the arcsine of a number in radians. |
| Atan | (number) | Atan(0.123) | Returns the arctangent of a number in radians. |
| Atn2 | (x_num, y_num) | Atn2(0.123, 1) | Returns the arctangent of the specified x- and y- coordinates in radians. |
| Ceiling | (number) | Ceiling(0.123) | Rounds a number up to the nearest integer. |
| Cos | (number) | Cos(0.123) | Returns the cosine of an angle. |
| Cot | (Number) | Cot(0.123) | Returns the cotangent of an angle. |
| Degrees | (number) | Degrees(0.123) | Converts radians to degrees. |
| Exp | (number) | Exp(0.123) | Returns e raised to the power of a given number. |
| Floor | (number) | Floor(0.123) | Rounds a number down to the nearest integer. |
| Log | (number) | Log(0.123) | Returns the natural logarithm of a number. |
| Log10 | (number) | Log10(0.123) | Returns the base-10 logarithm of a number. |
| Pi | () | Pi() | Returns the value of Pi. |
| Power | (number, power) | Power(123, 1) | Returns the result of a number raised to a power. |
| Radians | (number) | Radians(0.123) | Converts degrees to radians. |
| Rand | ([number]) | Rand(0.123) | Returns a random number between 0 and 1 using an optional number as a seed. |
| Round | (number, precision) | Round(0.123, 1) | Rounds a number to the specified length or precision. A positive precision indicates the number of digits after the decimal point. A negative precision indicates digits before the decimal point. |
| Sign | (number) | Sign(0.123) | Returns 1, 0, or -1 if the number is positive, zero, or negative, respectively. |
| Sin | (number) | Sin(0.123) | Returns the sine of an angle. |
| Sqrt | (number) | Sqrt(0.123) | Returns the square root of a number. |
| Square | (number) | Square(0.123) | Returns the square of a number. |
| Tan | (number) | Tan(0.123) | Returns the tangent of an angle. |
Text Functions
| Name | Parameters | Example | Description |
| Charindex | (string1, string2 [, start_location] | Charindex ('abc', 'b') | Searches string2 for string1 and returns its starting position if found. The search starts at start_location. |
| Left | (string, number) | Left ('abc', 2) | Returns the left part of a character string with the specified number of characters. |
| Len | (string) | Len ('abc') | Returns the number of characters in the string, without trailing spaces. |
| Lower | (string) | ('abc') | Returns the string converted to lowercase. |
| Ltrim | (string) | (' abc') | Returns the string without leading spaces. |
| Patindex | ('pattern', string) | ('bc', 'abcd') | Returns the starting position of the first occurrence of a pattern in a specified string, or zeros if the pattern is not found. Transact-SQL query wildcards can be used in the pattern. |
| Replace | (string1, strign2, string3) | ('abc', 'a', 'e') | Returns a copy of string1, where all occurrences of string2 are replaced by string3. |
| Reverse | (string) | ('abc') | Returns the reverse of a string. |
| Right | (string, number) | ('abc', 2) | Returns the right part of a character string with the specified number of characters. |
| Rtrim | (string) | ('abc ') | Returns the string without trailing spaces. |
| Space | (number) | (23) | Returns a string of repeated spaces. |
| Str | (number, [length [, precision]]) | (23) | Returns the number as a string, with a given length (default 10). Optional precision defines the number of digits after the decimal point, up to 16. |
| Stuff | (string1, start, length, string2) | ('abcde', 2, 1, 'def') | Inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position. |
| Substring | (string, start, length) | ('abcd', 2, 2) | Returns a substring starting at the starting position defined by start, with total length defined by length. |
| Upper | (string) | ('abc') | Returns the string converted to uppercase. |
Date Functions
| Name | Parameters | Example | Description |
| Dateadd | (datepart, number, date) | (minute, 1, '2011-01-08 05:13') | Adds the number to the specified datepart and returns the new date. |
| Datediff | (datepart, startdate, enddate) | (year, '2011-1-08', '1884-5-23') | Returns the difference between the specified dateparts of two dates. |
| Datepart | (datepart, date) | (weekday, '1884-5-23') | Returns the specified part of the date, as a number. |
| Day | (date) | ('2011-5-23') | Returns an integer representing the day (day of the month) of the specified date. |
| GetUTCDate | () | () | Returns the current system timestamp in UTC time. |
| Month | (date) | ('2011-5-23') | Returns an integer that represents the month of the specified date. |
| Year | (date) | ('2011-5-23') | Returns an integer that represents the year of the specified date. |
| IsDate | (expression) | ('2011-5-23') | Returns 1 if the expression is a valid date, time or datetime value, and 0 otherwise. |
| IsNull | (expression, replace_expression) | ([@field:country], 'USA') | Replaces NULL with the specified replacement value, otherwise returns the result of expression. |
| IsNumeric | (expression) | (23) | Returns 1 if expression is a valid number and 0 otherwise. |
| NullIf | (expression1, expression2) | ('abc','abc') | Returns the first expression if the two expressions are not equal. If the expressions are equal, returns a null value. |
Scaler Functions (Mathematical Operations)
| Name |
| + (add) |
| - (subtract) |
| * (multiply) |
| / (divide) |
| % (modulo) |
| & (bitwise AND) |
| | (bitwise OR) |
| ^ (bitwise XOR) |
| ~ (bitwise NOT) |
Aggregate Functions
| Name | |
| Count | Adds one to the total for each record |
| Count_Not_Blank | Adds one to the total for each record that contains data |
| Min | Displays the smallest record value |
| Max | Displays the largest record value |
| Sum | Displays the sum total of all record values |
| Avg | Displays the average of all record values |