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.