Answer to Question #246158 in Databases | SQL | Oracle | MS Access for Michael Sampson

Question

How is the pattern matching done in the SQL?

Answer 1

Pattern in SQL is done by using wildcard characters to match a pattern. 

For example the wildcard "M%" can be used to match any string beginning with M.

Example

SELECT *
FROM Students
WHERE surname LIKE '%K%'

The query above selects all details of student containing the letter K anywhere in the surname.