vbscript_ref_functions.asp

W3Schools tutorial..web designing

    <td valign="top">Converts a valid date and time expression to the variant of 
    subtype Date</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_cdbl.asp">CDbl</a></td>
    <td valign="top">Converts an expression to a variant of subtype Double</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_chr.asp">Chr</a></td>
    <td valign="top">Converts the specified ANSI code to a character</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_cint.asp">CInt</a></td>
    <td valign="top">Converts an expression to a variant of subtype Integer</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_clng.asp">CLng</a></td>
    <td valign="top">Converts an expression to a variant of subtype Long</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_csng.asp">CSng</a></td>
    <td valign="top">Converts an expression to a variant of subtype Single</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_cstr.asp">CStr</a></td>
    <td valign="top">Converts an expression to a variant of subtype String</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_hex.asp">Hex</a></td>
    <td valign="top">Returns the hexadecimal value of a specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_oct.asp">Oct</a></td>
    <td valign="top">Returns the octal value of a specified number</td>
  </tr>
  </table>

<br />
<table border="0" width="100%">
  <tr>
    <td width="70%" align="left"><h2><a name="format">Format Functions</a></h2></td>
    <td width="30%" align="right"><a href="#top">Top</a></td>
  </tr>
</table>
<table class="ex" cellspacing="0" width="100%" border="1">
  <tr>
    <th width="32%" align="left">Function</th>
    <th width="68%" align="left">Description</th>
  </tr>
  <tr>
    <td valign="top"><a href="func_formatcurrency.asp">FormatCurrency</a></td>
    <td valign="top">Returns an expression formatted as a currency value</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_formatdatetime.asp">FormatDateTime</a></td>
    <td valign="top">Returns an expression formatted as a date or time</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_formatnumber.asp">FormatNumber</a></td>
    <td valign="top">Returns an expression formatted as a number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_formatpercent.asp">FormatPercent</a></td>
    <td valign="top">Returns an expression formatted as a percentage</td>
  </tr>
  </table>
<br />

<table border="0" width="100%">
  <tr>
    <td width="70%" align="left"><h2><a name="math">Math Functions</a></h2></td>
    <td width="30%" align="right"><a href="#top">Top</a></td>
  </tr>
</table>
<table class="ex" cellspacing="0" width="100%" border="1">
  <tr>
    <th width="32%" align="left">Function</th>
    <th width="68%" align="left">Description</th>
  </tr>
  <tr>
    <td valign="top"><a href="func_abs.asp">Abs</a></td>
    <td valign="top">Returns the absolute value of a specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_atn.asp">Atn</a></td>
    <td valign="top">Returns the arctangent of a specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_cos.asp">Cos</a></td>
    <td valign="top">Returns the cosine of a specified number (angle)</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_exp.asp">Exp</a></td>
    <td valign="top">Returns <i>e</i> raised to 
    a power</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_hex.asp">Hex</a></td>
    <td valign="top">Returns the hexadecimal value of a 
    specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_int.asp">Int</a></td>
    <td valign="top">Returns the integer part of a specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_fix.asp">Fix</a></td>
    <td valign="top">Returns the integer part of a specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_log.asp">Log</a></td>
    <td valign="top">Returns the natural logarithm of a specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_oct.asp">Oct</a></td>
    <td valign="top">Returns the octal value of a specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_rnd.asp">Rnd</a></td>
    <td valign="top">Returns a random number less than 1 but greater or equal to 
    0</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_sgn.asp">Sgn</a></td>
    <td valign="top">Returns an integer that indicates the sign of a specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_sin.asp">Sin</a></td>
    <td valign="top">Returns the sine of a specified number (angle)</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_sqr.asp">Sqr</a></td>
    <td valign="top">Returns the square root of a specified number</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_tan.asp">Tan</a></td>
    <td valign="top">Returns the tangent of a specified number (angle)</td>
  </tr>
  </table>
<br />

<table border="0" width="100%">
  <tr>
    <td width="70%" align="left"><h2><a name="array">Array Functions</a></h2></td>
    <td width="30%" align="right"><a href="#top">Top</a></td>
  </tr>
</table>
<table class="ex" cellspacing="0" width="100%" border="1">
  <tr>
    <th width="32%" align="left">Function</th>
    <th width="68%" align="left">Description</th>
  </tr>
  <tr>
    <td valign="top"><a href="func_array.asp">Array</a></td>
    <td valign="top">Returns a variant containing an array</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_filter.asp">Filter</a></td>
    <td valign="top">Returns a zero-based array that contains a subset 
    of a string array based on a filter criteria</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_isarray.asp">IsArray</a></td>
    <td valign="top">Returns a Boolean value that indicates whether a 
    specified variable is an array</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_join.asp">Join</a></td>
    <td valign="top">Returns a string that consists of a number of substrings 
    in an array</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_lbound.asp">LBound</a></td>
    <td valign="top">Returns the smallest subscript for 
    the indicated dimension of an array</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_split.asp">Split</a></td>
    <td valign="top">Returns a zero-based, one-dimensional array that contains a 
    specified number of substrings</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_ubound.asp">UBound</a></td>
    <td valign="top">Returns the largest subscript for the 
    indicated dimension of an array</td>
  </tr>
  </table>
<br />

<table border="0" width="100%">
  <tr>
    <td width="70%" align="left"><h2><a name="string">String Functions</a></h2></td>
    <td width="30%" align="right"><a href="#top">Top</a></td>
  </tr>
</table>
<table class="ex" cellspacing="0" width="100%" border="1">
  <tr>
    <th width="32%" align="left">Function</th>
    <th width="68%" align="left">Description</th>
  </tr>
  <tr>
    <td valign="top"><a href="func_instr.asp">InStr</a></td>
    <td valign="top">Returns the position of the first occurrence of 
    one string within another. The search begins at the first character of the 
    string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_instrrev.asp">InStrRev</a></td>
    <td valign="top">Returns the position of the first occurrence of one string 
    within another. The search begins at the last character of the string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_lcase.asp">LCase</a></td>
    <td valign="top">Converts a specified string to lowercase</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_left.asp">Left</a></td>
    <td valign="top">Returns a specified number of characters from 
    the left side of a string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_len.asp">Len</a></td>
    <td valign="top">Returns the number of characters in a string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_ltrim.asp">LTrim</a></td>
    <td valign="top">Removes spaces on the left side of a string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_rtrim.asp">RTrim</a></td>
    <td valign="top">Removes spaces on the right side of a string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_trim.asp">Trim</a></td>
    <td valign="top">Removes spaces on both the left and the right side of a 
    string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_mid.asp">Mid</a></td>
    <td valign="top">Returns a specified number of characters from a 
    string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_replace.asp">Replace</a></td>
    <td valign="top">Replaces a specified part of a string with another string a 
    specified number of times</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_right.asp">Right</a></td>
    <td valign="top">Returns a specified number of characters from 
    the right side of a string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_space.asp">Space</a></td>
    <td valign="top">Returns a string that consists of a specified number of 
    spaces</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_strcomp.asp">StrComp</a></td>
    <td valign="top">Compares two strings and returns a value that represents 
    the result of the comparison</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_string.asp">String</a></td>
    <td valign="top">Returns a string that contains a repeating character of a 
    specified length</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_strreverse.asp">StrReverse</a></td>
    <td valign="top">Reverses a string</td>
  </tr>
  <tr>
    <td valign="top"><a href="func_ucase.asp">UCase</a></td>
    <td valign="top">Converts a specified string to uppercase</td>
  </tr>
  </table>
<br />

<table border="0" width="100%">
  <tr>
    <td width="70%" align="left"><h2><a name="other">Other Functions</a></h2></td>