Answered! Remember there are two wildcard characters for selecting rows: % matches one or more arbitrary characters _…

Remember there are two wildcard characters for selecting rows: % matches one or more arbitrary characters _ matches a single arbitrary character These are interpreted by the LIKE operator. Can you remember these two characters? Can you make a query using them?

Expert Answer

Wildcard Characters

The percent sign (%)
Matches one or more characters.
The underscore (_)
Matches one character.

Syntax for query

SELECT FROM TABLENAME
WHERE COLUMN LIKE 'XXX%'

SELECT FROM TABLENAME
WHERE COLUMN LIKE 'XXX_'

Still stressed from student homework?

Get quality assistance from academic writers!

Order now