5/9/08

What is wrong with the following SQL statement? SELECT * FROM authors WHERE au_lname LIKE M%

In the code provided, single apostrophes (') need to enclose M% so that the code reads
'M%'. Note that apostrophes are always used when the value in the WHERE clause is a
string value, but not used when the WHERE clause value is a numeral.

No comments: