If you need to query all People from Person table with FirstName start with A, you can easily query like below,
What if you want to list all the people from person table with first name start with A and B? You can combined Like operator with OR and query like below,
But imagine scenario where you need to query all the People with FirstName start with A to M. How will you do that?
Solution is you need to put like operator in the square bracket as below,
If you modify one little thing in above query and replace like operator with equal operator , you will get no error message however you will get no rows returned as well.