select studentID, FirstName, LastName, FirstName + ' ' + LastName as FullName
from student;