Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 24)
24.
The Microsoft Access wildcards are ____ and ____ .
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.
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.
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.
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:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers