Discussion :: Introduction to SQL - General Questions (Q.No.24)
| 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.