problem with functions

HI.......
I have a stored procedure
as follows:

ALTER procedure [dbo].[sp_getImagepath_delimiter]
@profile_id varchar(50)
as
declare
@photopath varchar(max)
begin
select @photopath=photos from registration_partnerprofile where profile_id=@profile_id
select photopath as 'Photo Path' from dbo.fn_imagepath(@photopath,',')
end
and i want to create a function as same as above but i m not able to create a function using the above statements.
can anyone help me with this. pls i need urgent..

Just like a procedure is created with a CREATE PROCEDURE script, a function is created with a CREATE FUNCTION script.

ok no need. i cleared ny doubt.