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
|
---|
Syntax for query
SELECT FROM TABLENAME WHERE COLUMN LIKE 'XXX%'
SELECT FROM TABLENAME WHERE COLUMN LIKE 'XXX_'