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..