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 Integer field
like "Year" and "Reference ID", you can use
">", "<", "between" condition. For
example:
Year > 1990
Year between 1990 and 1994
For data fields like
"Date", "Date of Input", "Date Modified",
date in ANSI format (yyyy-mm-dd) has to be used and it has to be inside a
single quote. You can use ">", "<",
"between" condition. For example:
Date of Input < '1999-09-12'
Date of Input between '1998-12-04' and '1999-03-21'