how do i change letter to numbers in sql for example
the code below: have so when a letter grade =that student haveit add it to the students gpa as a int for example
‘a’=4,b=’3′,c=’2′,d=’1’f=’0’ then say student1 has grades’abc’then 4+3+2/ the total possable
selectStudents.FirstName,Students.LastName,Students.StudentProgram,Students.Gradelevel,ClassGrades.Semester,ClassGrades.Grade, ClassGrades.Grade as CumlGpa
from ClassGrades
left join Students on Students.FirstName=ClassGrades.FirstName andStudents.LastName=ClassGrades.LastName
where ClassGrades.Grade!=’Currently enrolled’
Expert Answer
An answer will be send to you shortly. . . . .