遍历一个标的一个字段的函数

alter function F_GetUserPostion(@userName varchar(120)) returns varchar(600)
as
begin
declare @str varchar(600)
set @str=''
select @str=@str+isnull((select column_Name from Hr_Professional where Column_id=Hr_Intention.GSsortID),'') from Hr_Intention where GuserName=@userName
return @str
end
go