Why is it that when I run the following query against your database in the SQL Server management studio:
select * from Genre
where Name Like "Pop"
I get the following error:
Msg 207, Level 16, State 1, Line 2
Invalid column name 'Pop'.
I get the same error message with the following query as well.
select Id from Genre
where Name like "Pop%"
Isn't that the way a that like statement is supposed to look like??? Am I missing something here???!!! I am noting short of super confused on this one like you wouldn't believe. Any help on this would be so greatly appreciated.