List:General Discussion« Previous MessageNext Message »
From:chamila gayan Date:March 15 2010 7:57am
Subject:udf return column name not value
View as plain text  
CREATE FUNCTION getcolumnvalue(id int,columnname varchar(30))
RETURNS varchar(50) DETERMINISTIC
READS SQL DATA
begin
declare retval varchar(50);
select columnname into retval from user where ID = id ;
return retval;
end;

I want get value of related column but it return column name.
ex:- ('tom' what I want but it return 'name')
plz tell what the wrong of this

thank you

Thread
udf return column name not valuechamila gayan15 Mar
  • RE: udf return column name not valueGavin Towey15 Mar
    • Re: udf return column name not valuechamila gayan16 Mar