SQL Server : Can a user-defined function return a text value ?

NO.

SQL user-defined functions cannot return text,ntext or image.


http://msdn.microsoft.com/en-us/library/aa258261(v=SQL.80).aspx
can be any of the scalar data types supported by SQL Server, except text, ntext, image, and timestamp.