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.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

SQL query case

SQL query case

0
Votes
1
Answer

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.
Best,
Martin

Alright, Thank you for the clarification!!

6 months

You are welcome!

6 months