SQL Reference

Index
A
ABS function 30
aggregate functions in SQL 28
ALL operator 26
ALTER TABLE (SQL statement) 21
AND operator 27
ANY operator 26
ATAN function 30
ATAN2 function 30
B
BETWEEN operator 25
binary data, use in SELECT 15
blank characters 25
blank value in columns 18
BLOB data type, use in SELECT 15
C
CASE WHEN function 32
CAST function 16
CEIL function 30
CEILING function 30
character operators in SQL expressions 25
CHR function 29
COALESCE function 33
column aliases 8
constants in SQL expressions 23
container field
stored externally 21
with CREATE TABLE statement 21
with GetAs function 16
with INSERT statement 18
with PutAs function 18
with SELECT statement 16
with UPDATE statement 19
CREATE INDEX (SQL statement) 22
CREATE TABLE (SQL statement) 20
CURDATE function 32
CURRENT USER function 29
CURRENT_DATE function 32
CURRENT_TIME function 32
CURRENT_TIMESTAMP function 32
CURRENT_USER function 29
cursors in ODBC 14
CURTIME function 32
CURTIMESTAMP function 32
D
date formats 23
DATE function 32
date operators in SQL expressions 25
DATEVAL function 32
DAY function 30
DAYNAME function 29
DAYOFWEEK function 30
DEFAULT (SQL clause) 20
DEG function 30
DEGREES function 30
DELETE (SQL statement) 17
DISTINCT operator 8
documentation 5
DROP INDEX (SQL statement) 22
E
empty string, use in SELECT 15
ExecuteSQL function 6
, 7
EXISTS operator 26
EXP function 31
exponential notation in SQL expressions 24
expressions in SQL 23
EXTERNAL (SQL clause) 21
F
FETCH FIRST (SQL clause) 13
field names in SQL expressions 23
field repetitions 17
, 20
FileMaker Server
documentation 5
files, use in container fields 16
FLOOR function 31
FOR UPDATE (SQL clause) 14
FROM (SQL clause) 9
FULL OUTER JOIN 10
functions in SQL expressions 28
G
GetAs function 16
GROUP BY (SQL clause) 11
H
HAVING (SQL clause) 11
HOUR function 31
I
IN operator 25
INNER JOIN 10
INSERT (SQL statement) 17
INT function 31
IS NOT NULL operator 25
IS NULL operator 25