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

Don't use plagiarized sources. Get Your Custom Essay on
Answered! Remember there are two wildcard characters for selecting rows: % matches one or more arbitrary characters _…
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay
  • 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!