ASP function syntax quick query table

Abs (numerical value)
Absolute value. The absolute value of a number is its positive value. The absolute value of a null string. Uninitialized variable, which is absolutely 0
Example: ABS (-2000)
Result: 2000
Array (Array elements separated by commas)
The Array function returns the value of an Array element.
Example:
A = Array (1, 2, 3)
B = A (2)
Result: 2
Note: variable B is the value of the second element of array.
Asc (string)
Converts the first letter of a string to an ANSI (American National Standard) character.
Example: Asc ("Internet ")
Result: 73
Description: displays the ANSI code of the first letter I.
CBool (expression)
Convert to a Boolean logical value variable type (True or False)
Example: CBool (1 + 2)
Result: True.
CDate (date expression)
Change to date variable type. You can use the IsDate function to determine whether the data can be converted to a date.
Example: CDate (now () + 2)
Result: 10:30:59
CDbl (expression)
Convert to DOUBLE variable type.
Chr (ANSI code)
Converts an ASCII code to a character.
Example: Chr (72)
Result: H
CInt (expression)
Convert to an integer variable type.
Example: CInt ("3.12 ")
Result: 3
CLng (expression)
Convert to LONG variable type.
CSng)
Convert to SINGLE variable type.
CStr (expression)
Convert to string variable type.
Date () top
Returns the date of the system.
Example: Date
Result: 2000/5/13
DateAdd (I, N, D)
Add a date to the date after a period.
I: set the unit of a period added by a Date. For example, interval = "d" indicates that the unit of N is day.
I is set as follows:
Yyyy Year
Q Quarter
M Month
D Day
W Weekday
H Hour
N Minute points
S Second seconds
N: a numeric expression that specifies the period of a date. It can be a positive or negative value. A positive value indicates a plus (the result is a date after date ), negative value indicates subtraction (Result:> date before date ).
D: date to be added or subtracted.
Example: DateAdd ("m", 1, "31-Jan-98 ")
Result: 28-Feb-98
Note: If the date is 31-Jan-98 plus one month, the result is 28-Feb-98 rather than 31-Fe-98.
Example: DateAdd ("d", 20, "30-Jan-99 ")
Result:
Note: add a date of 30-Jan-99 plus a date of 20 days.