Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.24)

24. 

The Microsoft Access wildcards are ____ and ____ .

[A]. asterisk (*); percent sign (%)
[B]. percent sign (%); underscore (_)
[C]. underscore(_); question mark (?)
[D]. question mark (?); asterisk (*)

Answer: Option D

Explanation:

No answer description available for this question.

Shiwam said: (Sep 19, 2011)  
Please explain.

Rani said: (Oct 2, 2011)  
Please please explain.

Swathi said: (Dec 23, 2011)  
Please provide explanation for the question and related queries.

Dharmendra Benawat said: (May 16, 2013)  
But SQl is use the % and _ is character.

Access is use * and ? is character.

Vijay Kumar said: (Jul 23, 2015)  
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.

Pooja said: (Dec 25, 2016)  
What is MS Access?

Manushree Sm said: (Feb 28, 2017)  
Please tell me, what is ms access?

Aswini said: (Sep 18, 2018)  
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.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.