Database - Introduction to SQL - Discussion

Discussion Forum : Introduction to SQL - General Questions (Q.No. 24)
24.
The Microsoft Access wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
8 comments Page 1 of 1.

Aswini said:   5 years ago
Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

The per cent sign (%) Matches one or more characters. Note that MS Access uses the asterisk (*). Wildcard character instead of the per cent sign (%) wildcard character.

MS Access uses a Question mark (?) instead of the underscore (_) to match any one character.

Manushree sm said:   6 years ago
Please tell me, what is ms access?

Pooja said:   6 years ago
What is MS Access?

Vijay Kumar said:   8 years ago
SQL supports following two wildcard operators in conjunction with the LIKE operator:

Wildcards Description.

The percent sign (%) Matches one or more characters. Note that MS Access uses the asterisk (*). Wildcard character instead of the percent sign (%) wildcard character.

The underscore (_) Matches one character.

Note that MS Access use a Question mark (?) instead of the underscore (_) to match any one character.

The percent sign represents zero, one, or multiple characters. The underscore represents a single number or character. The symbols can be used in combinations.

Dharmendra Benawat said:   10 years ago
But SQl is use the % and _ is character.

Access is use * and ? is character.

Swathi said:   1 decade ago
Please provide explanation for the question and related queries.

Rani said:   1 decade ago
Please please explain.

Shiwam said:   1 decade ago
Please explain.

Post your comments here:

Your comments will be displayed after verification.