| 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 value | chamila gayan | 15 Mar |
| • RE: udf return column name not value | Gavin Towey | 15 Mar |
| • Re: udf return column name not value | chamila gayan | 16 Mar |
