title: SQL Syntax Problem: How do I get the first 4 letters and Uppercase
body: <p>I am having a hard time getting the value in the database with a constraint of getting only the <strong>first 4 letters of the name</strong> as well as its in <strong>uppercase</strong>.</p>
  <p>I am using MySQL on Command Prompt and so far I have tried this syntax and I always get this error,</p>
  <p><em><strong>You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM STUDENTS' at line 1</strong></em></p>
  <p>The syntax I have tried;</p>
  <p>SELECT UCASE(MID(NAME,1,3) FROM STUDENTS;</p>
  <p>SELECT UPPER(SUBSTRING(NAME,1,3) FROM STUDENTS;</p>
  <p>Tried all of them but I am still getting errors. Do you guys have any idea where I might be wrong?</p>