Question

What will happen if in the above query we write “Aaliya” as “AALIYA” or “aaliya” or “AaLIYA”? Will the query generate the same output or an error?

Answer 1

If the query is written with “Aaliya” as “AALIYA”, “aaliya”, or “AaLIYA”, it will generally generate the same output because SQL text comparisons are usually not case-sensitive.

Thus, all these forms will match “Aaliya” in the database.