Function

Must be stored in db.

Create Procedure Present (@dateX datetime).

Returns Varchar.

As.

Begin

Declare @status varchar.

If @dateX IS NULL

Set @status = "Absent".

else

Set @status = "Present".

Return @status.

End.

Go.