Advertisements
Advertisements
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?
Very Short Answer
Advertisements
Solution
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.
shaalaa.com
Is there an error in this question or solution?
