|
Access SQLServer 関数対比表
|
|
|
| 文字列関数 |
| 関数 |
VBA |
SQLServer |
| 文字から ASCII |
Asc (String As String) |
ASCII (character_expression) |
| ASCII から文字 |
Chr$ (CharCode As Long) |
CHAR (integer_expression) |
| 文字を小文字に変換 |
Lcase$ (String As String) |
LOWER (character_expression) |
| 文字列の長さ |
Len (Expression) |
DATALENGTH (expression)
LENGTH (expression) |
| 先行する空白の除去 |
Ltrim$ (String) |
LTRIM (character_expression) |
| 部分文字列 |
Mid$ (String As String, Start As Long, [Length]) |
SUBSTRING (expression, start, length) |
| 右端からの部分文字列 |
Right$ (String As String, Start As Long) |
RIGHT (character_expression, integer_expression) |
| 先行する空白の除去 |
Rtrim$ (String) |
RTRIM (character_expression) |
| 反復する空白からなる文字列 |
Space$ (Number As Long) |
SPACE (integer_expression) |
| 数値データから変換された文字データ |
Str$ (Number) |
STR (float_expression [, length [, decimal ] ]) |
| 文字を大文字に変換 |
Ucase$ (String) |
UPPER (character_expression) |
| 変換関数 |
| 関数 |
VBA |
SQLServer |
| Currency 型に変換 |
Ccur (Expression) |
CONVERT (money, expression) |
| Double 型に変換 |
Cdbl (Expression) |
CONVERT (float, expression) |
| Integer 型に変換 |
Cint (Expression) |
CONVERT (smallint, expression) |
| Long 型に変換 |
Clng (Expression) |
CONVERT (int, expression) |
| Single 型に変換 |
Csng (Expression) |
CONVERT (real, expression) |
| String 型に変換 |
Cstr (Expression) |
CONVERT (varchar[ (length) ], expression) |
| 日付型に変換 |
Cvdate (Expression)
CDate (Expression) |
CONVERT (datetime, expression) |
| 日付関数 |
| 関数 |
VBA |
SQLServer |
| 日付の加算 |
Dateadd (Interval As String,
Number As Double, Date) |
DATEADD (datepart, number, date) |
| 日付の減算 |
Datediff (Interval As String, Date1, Date2) |
DATEDIFF (datepart, startdate, enddate) |
| 日付の整数表現 |
Datepart (Interval As String, Date) |
DATEPART (datepart, date) |
| 日付の整数表現(日) |
Day (Date) |
DATEPART (dd, date) |
| 日付の整数表現(時) |
Hour (Time) |
DATEPART (hh, date) |
| 日付の整数表現(分) |
Minute (Time) |
DATEPART (mi, date) |
| 日付の整数表現(月) |
Month (Date) |
DATEPART (mm, date) |
| システム日付 |
Now () |
GETDATE () |
| 日付の整数表現(秒) |
Second (Time) |
DATEPART (ss, date) |
| 日付の整数表現(曜日) |
Weekday (Date) |
DATEPART (dw, date) |
| 日付の整数表現(年) |
Year (Date) |
DATEPART (yy, date) |
| 数学関数 |
| 関数 |
VBA |
SQLServer |
| 整数部を返す |
Int (Number) |
FLOOR (numeric_expression) |
| 数の符号 |
Sgn (Number) |
SIGN (numeric_expression) |
| 四捨五入 |
Round (Number, [NumDigitsAfterDesical As Long]) |
ROUND (numeric_expression, length [, function ]) |
| 乱数 |
Rnd ([Number]) |
RAND ([ seed ]) |
