-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: convertor00
Message 3 in Discussion
Math Functions Function Oracle SQL Server Absolute value ABS ABS Arc
cosine ACOS ACOS Arc sine ASIN ASIN Arc tangent of n ATAN ATAN Arc tangent
of n and m ATAN2 ATN2 Smallest integer >= value CEIL CEILING Cosine COS COS
Hyperbolic cosine COSH COT Exponential value EXP EXP Round down to nearest
integer FLOOR FLOOR Natural logarithm LN LOG Logarithm, any base LOG(N) N/A
Logarithm, base 10 LOG(10) LOG10 Modulus (remainder) MOD USE MODULO (%)
OPERATOR Power POWER POWER Random number N/A RAND Round ROUND ROUND Sign of
number SIGN SIGN Sine SIN SIN Hyperbolic sine SINH N/A Square root SQRT SQRT
Tangent TAN TAN Hyperbolic tangent TANH N/A Truncate TRUNC N/A Highest
number in list GREATEST N/A Lowest number in list LEAST N/A Convert number if
NULL NVL ISNULL String Functions Function Oracle SQL Server Convert
character to ASCII ASCII ASCII String concatenate CONCAT (expression +
expression) Convert ASCII to character CHR CHAR Return starting point of
character in character string (from left) INSTR CHARINDEX Convert characters
to lowercase LOWER LOWER Convert characters to uppercase UPPER UPPER Pad left
side of character string LPAD N/A Remove leading blank spaces LTRIM LTRIM
Remove trailing blank spaces RTRIM RTRIM Starting point of pattern in
character string INSTR PATINDEX Repeat character string multiple times RPAD
REPLICATE Phonetic representation of character string SOUNDEX SOUNDEX String
of repeated spaces RPAD SPACE Character data converted from numeric data
TO_CHAR STR Substring SUBSTR SUBSTRING Replace characters REPLACE STUFF
Capitalize first letter of each word in string INITCAP N/A Translate character
string TRANSLATE N/A Length of character string LENGTH DATALENGTH or LEN
Greatest character string in list GREATEST N/A Least character string in list
LEAST N/A Convert string if NULL NVL ISNULL Date Functions Function Oracle
SQL Server Date addition (use +) DATEADD Date subtraction (use -) DATEDIFF
Last day of month LAST_DAY N/A Time zone conversion NEW_TIME N/A First
weekday after date NEXT_DAY N/A Convert date to string TO_CHAR DATENAME
Convert date to number TO_NUMBER(TO_CHAR()) DATEPART Convert string to date
TO_DATE CAST Get current date and time SYSDATE GETDATE()
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
