-- SET NOCOUNT ON added to prevent extra result sets from

SET NOCOUNT ON;
		SELECT  student_id, fname, lname, dob, ACCT_BAL
		FROM STUDENT
		WHERE upper(STUDENT_ID) like upper( @studentid   )
		or upper(lname) like upper( @lname   )
		or dob = @dob