Discussion :: Introduction to SQL - General Questions (Q.No.24)
|Shiwam said: (Sep 19, 2011)|
|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:
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:
Email : (optional)
» Your comments will be displayed only after manual approval.