Databases Cont'

You can use relational operators which are
>
<
<=
>=
<>
=

anything with talking marks is case sensitive.
using % at the beginning of R will show what ends in R
% signs are called a wild card character
you can also put % at beginning and end and it will look at the beginning and end.
'This R% brings up locations starting with R
'%R anything that ends with R
'%R% starting and ending with R
'Use [] where a space has been inserted in name

logical operators
AND
OR
we can also use these in the expressions that we are making

And will only find from one section
Or will find from all sections