how pass parameter to function

Try this

create table table1
 (
 id int,
 name char(10),
 dept varchar(20))
   
insert into table1 values(1,'aa','1,2,3,4,5')
insert into table1 values(3,'bb','1,2,3')



CREATE FUNCTION test_fun(@name varchar(20) )
 RETURNS varchar 
AS 
BEGIN 
RETURN @name
end


SELECT dbo.test_fun(name) from table1

--Prashanth