What is the wildcard character that stands for any single character in criteria?

20.The wildcard character that stands for any group of characters is the ____.a.Period (.)c.Asterisk (*)b. Semicolon (;)d. Plus sign (+)

21.The wildcard character that stands for any single character is the ____.

22.A(n) ____ is a saved view of the data whose criteria is not discarded when you close the datasheet.

23.Criteria ____ is the term for rules by which criteria must be entered in a query.

24.____ are rules or limiting conditions you set to determine which records will be selected in a filter orquery.a.Criteriac.Queriesb. Filtersd.None of the above

25.To find all records where there is any entry in the field, even if the entry is 0, use which criteria?*=*

26.____ will find all records where there is any entry in the field, even if the entry is 0.AndPTS: 1REF: Access 36

27.Which of the following comparison operators means "not equal to"?<>

28.To find numbers greater than or equal to 500, use which comparison operator?a.<>c.b. <=d.>>>=

29.Which of the following comparison operators means "greater than"?<

30.Which of the following comparison operators means "less than or equal to"?<<=

This chapter describes the special characters that can be used in Text queries. In addition, it provides a list of the words and characters that interMedia Text treats as reserved words and characters.

The following topics are covered in this chapter:

• Wildcard Characters

• Grouping Characters

• Escape Characters

• Reserved Words and Characters

Wildcard Characters

Wildcard characters can be used in query expressions to expand word searches into pattern searches. The wildcard characters are:

For example, the following query expression finds all terms beginning with the pattern scal:

'scal%'

To find words such as king, wing or sing, you can write your query as follows:

'_ing'

When a wildcard expression translates to a stopword, the stopword is not included in the query and not highlighted by CTX_DOC.HIGHLIGHT or CTX_DOC.MARKUP.  

Grouping Characters

The grouping characters control operator precedence by grouping query terms and operators in a query expression. The grouping characters are:

The beginning of a group of terms and operators is indicated by an open character from one of the sets of grouping characters. The ending of a group is indicated by the occurrence of the appropriate close character for the open character that started the group. Between the two characters, other groups may occur.

For example, the open parenthesis indicates the beginning of a group. The first close parenthesis encountered is the end of the group. Any open parentheses encountered before the close parenthesis indicate nested groups.

Escape Characters

To query on words or symbols that have special meaning to query expressions such as and & or| accum, you must escape them. There are two ways to escape characters in a query expression:

In the following examples, an escape sequence is necessary because each expression contains a Text operator or reserved symbol:

'AT\&T'
'{AT&T}'

'high\-voltage'
'{high-voltage}'

If you use braces to escape an individual character within a word, the character is escaped, but the word is broken into three tokens.

For example, a query written as high{-}voltage searches for high - voltage, with the space on either side of the hyphen.  

Querying Escape Characters

The open brace { signals the beginning of the escape sequence, and the closed brace } indicates the end of the sequence. Everything between the opening brace and the closing brace is part of the escaped query expression (including any open brace characters). To include the close brace character in an escaped query expression, use }}.

To escape the backslash escape character, use \\.

Reserved Words and Characters

The following table lists the iMT reserved words and characters that must be escaped when you want to search them in CONTAINS queries:

Which character is used as a wildcard symbol in query Design?

What is criteria using wildcard?

Which wildcard character represents a single character in the same position as the wildcard?

Which of the following wildcard characters could he use to search for a single character?