Query relevant to chapter 6.LIKE II - using BETWEEN function


In the example I had to find movie titles between the range A to J which was successful using the below statement.

SELECT * FROM movies

I tried modifying the above statement to look for genre between A to J using the below statement but showed no query result

SELECT * FROM movies WHERE genre BETWEEN 'A' and 'C';

Could anyone point out what is the problem ,both name and genre use text syntax.

Thanks in advance


a and A are not the same when you are doing SQL queries. If you have a look at the genres you will see that they are all lower case. That means that it is correct that you found no hits for

WHERE genre BETWEEN 'A' and 'C'

Can you see what you must do now?