Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 11)
11.
The SQL keyword(s) ________ is used with wildcards.
Discussion:
14 comments Page 2 of 2.
Gayatri said:
9 years ago
A wildcard character can be used to substitute for any other character(s) in a string. SQL wildcards are used to search for data within a table.
For Example1:
SELECT * FROM Customers
WHERE City LIKE 'ber%';
//Displays table containing city starting with Ber...//
For Example2:
SELECT * FROM Customers
WHERE City LIKE '%es%';
//Displays table containing city ending with es...//
For Example1:
SELECT * FROM Customers
WHERE City LIKE 'ber%';
//Displays table containing city starting with Ber...//
For Example2:
SELECT * FROM Customers
WHERE City LIKE '%es%';
//Displays table containing city ending with es...//
(3)
Ramesh said:
9 years ago
Wildcard is special character is represent to another character.
Like as run* -->then result get out run, runing, runs.
Like as run* -->then result get out run, runing, runs.
(1)
Sufi said:
9 years ago
Thanks, Now my doubt on wildcard is much cleared.
Argha Sarkar said:
8 years ago
Thank you.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers