|
Databases -
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Exercise 1
Exercise 2
|
 |
Community Learning Homepage |
<< PREVIOUS
15 - Query Examples
NEXT >>
| Text Examples |
Result |
| “Wembley” |
Finds Wembley |
| Like “S*” |
Finds word beginning with S. (Note! the asterix ‘*’ is used as a substitute for the other letters in that word. |
| >Dan |
Finds any name after Dan in alphabetical order e.g. Dawn through to Z |
| ”Harrow” or “Kilburn” |
Finds Harrow or Kilburn |
| Not “London” |
Finds all cities except London |
| In(Manchester,Bristol,Leeds) |
Finds Manchester, Bristol and Leeds |
| Between Harry and Sally |
Finds all names alphabetically between Harry and Sally |
| Number Examples |
Result |
| =62 |
Find numbers equal to 62 |
| <88 |
Finds numbers less than 88 |
| >=25 |
Finds number greater than and equal to 25 |
| <>10 |
Finds numbers not equal to 10 |
| Between 22 and 50 |
Finds numbers between 22 and 50 |
| Date Examples |
Result |
| #05/02/04# |
Finds dates equal to 05/02/04 |
| >#10/06/03# |
Finds dates later than 10/06/03 |
| <#23/12/02# |
Finds dates earlier than 23/12/02 |
| <>#18/04/02# |
Finds dates not equal to 18/04/02 |
Between #18/04/02# and #23/12/02# |
Finds dates between 18/04/02 and 23/12/02 |
| Like #*/02/04# |
Finds any date in February 2004 |
<< PREVIOUS - NEXT >>
|
