Basic already written but in fuzzy query that blocks out of the question
The CREATE FUNCTION stu_sln (@ spe CHAR (10))
RETURNS the @ REAULT TABLE
(Cname CHAR (20), GRADE SMALLINT)
AS
The BEGIN
INSERT the @ REAULT
SELECT a Cname, Grade
The FROM SC, Course, Student
WHERE SC. Cno=Course. Cno AND SC. Sno=Student. Sno AND Sname LIKE CAST (@ the spe as char (10)) + '%'
RETURN
END

Excuse me,
what is the problem?Thanks for your bosses!