The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

SQL query case

SQL query case


Databases are not case sensitive but I can see that keywords are also not case sensitive. In that case can I still use lower case instead of upper case or is it advisable to use only upper case?

1 Answer

365 Team

Hi Neelanjan!
Thanks for reaching out!
Yes, you are right; you are free to choose whether to use upper or lower case. We stick to using upper case for keywords as much as possible because we thing this improves the legibility of your code and this is always a good characteristic for your code.
However, the code you are writing will have just the same functionality if you were using lower case letters only. In that situation, you would rely on the altered colour of the keyword letters from black to blue (that’s what Workbench does automatically). So, it is up to you, your company, or any other standard how to write your code. Theoretically, that’s how it usually works.
Hope this helps.

Alright, Thank you for the clarification!!

10 months

You are welcome!

10 months
Complete Data Science Education
Get 50% OFF