Advanced search can
let you do a more refined search. For example, you can specify a query
to find all records that are published after "1990" by
"Smith".
"_"
wildcard character matches any single character. "%" matches
any sequence of zero or more characters. It is not necessary to use
"%" wildcard at the beginning and end of a query.
For data fields like
"Date Created" and "Date Published", date has to be
entered in ANSI format (yyyy-mm-dd) and it has to be inside a single
quote. You can use ">", "<",
"between" condition. For example:
Date Published < '1999-09-12'
Date Published between '1998-12-04' and '1999-03-21'