COMPUTER PROGRAMMING FUNDAMENTALS
WHAT IS PROGRAMMING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following wildcard character represents a single character in SQL?
|
|
Ampersand(&)
|
|
|
Underscore ( ____ )
|
|
|
Percentage (%)
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -A wildcard character in SQL is used with the LIKE clause to replace a single or set of characters in any string. For example, SELECT * FROM Customers WHERE last name LIKE ‘R%’; Run Code. Here, % (means zero or more characters) is a wildcard character.
Detailed explanation-2: -SQL supports two wildcard operators in conjunction with the LIKE operator which are explained in detail in the following table. Sr.No. Matches one or more characters. Note − MS Access uses the asterisk (*) wildcard character instead of the percent sign (%) wildcard character.
There is 1 question to complete.