Inside Back Cover

Inside Back Cover

Table of VBScript Functions

Function	Returns
Abs	The absolute value of a number.
Array	A variant containing an array.
Asc	The ASCII character code of a character or the first character of a string.
Atn	The Arc tangent of a number.
Cbool	The Boolean value of an expression passed into the function.
Cbyte	A number of type byte, converted from a number passed into the function.
Cdate	A date type, converted from a valid date expression passed into the function.
CDbl	A variant of subtype double from an expression passed into the function.
Chr	The ASCII character of an ASCII code.
Cint	A variant of subtype Integer from an expression passed into the function.
CLng	A variant of subtype long after the expression passed into the function is converted into long.
Cos	The cosine of an angle.
CSng	A variant of subtype Single from a numerical expression.
CStr	A string from an expression.
CVErr	A user specified error code.
Date	The date from the system clock.
DateSerial	Calculations of various days based on current date.
DateValue	A variant of subtype date.
Day	A value between 1 and 31 and can be used to find the day of a date.
Exp	The value of e raised to a power.
Hex	The hexadecimal (base 16) value of a numerical expression.
Hour	The number of hours of a time expression.
InputBox	A dialog box prompt.
InStr	The location of one string in another string.
Int, Fix	Integers from numerical expressions.
IsArray	True if a variable is an array and False otherwise.
IsDate	True if an expression can be converted to a valid date and False otherwise.
IsEmpty	True if a variable has been initialized and False otherwise.
IsError	True if an expression is an error code and False otherwise.
IsNull	True if an expression is NULL and False otherwise.
IsNumeric	True if an expression is numeric and False otherwise.
IsObject	True if an expression references an OLE Automation Object and False otherwise.
Lbound	The minimum index of an array dimension.
Lcase	The lowercase value of a string expression.
Left	A certain number of characters from the left side of a string.
Len	The number of characters of a string expression.
Log	The natural logarithm of a nonnegative numerical expression.
Ltrim	String after eliminating preceding spaces.
Mid	A certain number of characters from a string.
Minute	The number of minutes when called with the time.
Month	The month when called with a date.
MsgBox	A message box.
Now	The current date and time from the system clock.
Oct	The octal value (base 8) of a numerical expression.
Right	A certain number of characters from the right side of a string.
Rnd	A random number between 1 and 0.
Rtrim	String after eliminating trailing spaces.
Second	The number of seconds of a date expression.
Sgn	The sign of a numerical expression.
Sin	The Sine of an angle.
Sqr	The square root of a nonnegative numerical expression.
Str	A string converted from a numerical expression.
StrComp	The values of a string comparison.
String	A character value repeated N times.
Tan	The tangent of an angle.
Time	The current time from the system clock.
TimeSerial	Time calculations based on current time.
TimeValue	Expression passed into the function after converting it into a variant of subtype Date.
Trim	String after eliminating both trailing and preceding spaces.
Ubound	The maximum size of an array dimension.
Ucase	The uppercase value of a string expression.
Val	A number contained in a string.
VarType	The type of a variable.
Weekday	A number between 1 and 7, for days of a week.
Year	The year of the expression.

For more information on VBScript, turn to Chapter 12, "Unleashing the Power of VBScript."