Jet SQLで使える関数
| ABS | array | ASC | ASCB | ASCW | ATN |
| CBOOL | CBYTE | CCUR | CDATE | CDBL | choose |
| CHR | CHR$ | CHRB | CHRB$ | CHRW | CHRW$ |
| CINT（未） | CLNG | COS | CSNG | CSTR | CVAR |
| CvDate | CVErr | date | DATE$ | DATEADD | dateDiff |
| datePart | DATESERIAL | DATEVALUE | day | DDB | error |
| error$ | EXP | FIX | format | format$ | fv |
| hex | hex$ | HOUR | IIF | IMEStatus | inStr |
| INT | IPMT | IRR | isDate | isEmpty | ISERROR |
| isNull | isNumeric | isObject | lCase | lCase$ | LEFT |
| LEFT$ | LEFTB | LEFTB$ | LEN | LENB | LOG |
| lTrim | lTrim$ | MID | MID$ | MIDB | MIDB$ |
| MINUTE | MIRR | MONTH | NOW | NPER | NPV |
| oct | oct$ | partition | PMT | PPMT | PV |
| QBColor | RATE | RGB | RIGHT | RIGHT$ | RIGHTB |
| RIGHTB$ | rnd | round | rTrim | rTrim$ | SECOND |
| sgn | SIN | SLN | space | space$ | sqr |
| str | str$ | strComp | strConv | string | string$ |
| switch | SYD | TAN | TIME | TIME$ | timer |
| timeSerial | TIMEVALUE | TRIM | TRIM$ | typeName | uCase |
| uCase$ | val | varType | WEEKDAY | YEAR |
最終更新日：2008-06-18
