1271
less-than operator, 177, 188
in select queries, 188
# (pound sign)
Date comparisons, 152
hyperlink indicator, 65–66
optional digit indicator, 67
placeholder, 62
wildcard character, 181
? (question mark)
optional letter indicator, 67
wildcard character, 181, 195–198
/ (slash)
date delimiter, 625
division operator, 174, 188
input mask separator, 67
integer division operator, 175
in select queries, 188
separating time elements, 63
: (colon)
compiler argument separator, 414
date/time separator, 67
time element separator, 63
, (comma)
field separator, 620
thousands separator, 62, 67. (period)
date delimiter, 625
decimal points, 62, 67
in With keyword, 895
table and field name separator, 174
; (semicolon)
input mask separator, 67
SQL end-of-statement indicator, 484
< > (angle brackets)
not-equal operator, 176, 188, 198–199
in select queries, 188
[ ] (square brackets)
around field names, 476–477
pattern indicator, 181
referencing fields, 192–193
table and field name notation, 174
Symbols and Numerics
& (ampersand)
any character or digit required, 67
concatenation operator, 173, 178–179, 188, 422
continuation character, 419
optional character indicator, 64
in select queries, 188
* (asterisk)
filling empty spaces, 60
multiplication operator, 174, 188
new record indicator, 221–222
in select queries, 188
wildcard character, 181, 195–198, 477
“...” (double quotes)
around returned strings, 178
literal text indicator, 60, 194
text qualifier, 620, 624
= (equal sign)
assignment operator, 422
equal operator, 176, 188
in select queries, 188
! (exclamation point)
displaying input masks, 67
in With keyword, 895
left-aligning a display, 60
left-aligning text, 60
> (greater-than sign)
convert to uppercase, 64, 67
Date comparison operator, 152
greater-than operator, 177, 188
in select queries, 188- (hyphen)
input mask separator, 67
range indicator, 181
in select queries, 188
subtraction operator, 173–174, 188
< (less-than sign)
convert to lowercase, 64, 67
Date comparison operator, 152
52_475348-bindex.indd 127152_475348-bindex.indd 1271 4/1/10 2:01 PM4/1/10 2:01 PM