MS Access
NO
NO
NO
YES
ODBC
YES
NO
YES
YES
+
Y
UNION
YES
YES
N
Y
+' '+
Y
Q
N
N
N
Y
MSys
NO
NO
'dd/mm/yyyy HH:m:s'
{!d 'yyyy-mm-dd'}
.
DatePart('YYYY', $D)
DatePart('Q', $D)
DatePart('M', $D)
+
-
*
/
NOT
OR
XOR
AND
IS NOT NULL
IS NULL
>=
<=
=
<>
>
<
IN
NOT IN
LIKE
NOT LIKE
BETWEEN AND
NOT BETWEEN AND
Mod
Imp
^
Eqv
min($1)
max($1)
avg($1)
sum($1)
count($1)
{fn ascii($1)}
{fn char($1)}
{fn concat($1,$2)}
left($1,$2)
ltrim($1)
len($1)
instr($1,$2)
lcase($1)
right($1,$2)
rtrim($1)
mid($1,$2,$3)
ucase($1)
abs($1)
cos($1)
{fn ceiling($1)}
exp($1)
{fn floor($1)}
log($1)
{fn mod($1,$2)}
rnd($1)
sgn($1)
sin($1)
sqrt($1)
tan($1)
date()
{fn dayofweek($1)}
{fn dayofmonth($1)}
{fn dayofyear($1)}
int({fn week($1)})
{fn month($1)}
{fn year($1)}
datepart('q',$1)
int($1)
strcomp($1,$2,$3)
now()
IIf($1, $2, $3)
choose($1, $2)
isnull($1)
@prompt($1,'A',,,)
@prompt($1,'N',,,)
@prompt($1,'D',,,)
LEFT($1,LEN($1))
LEFT($1,LEN($1))