sql function return question

[rsshetty]

what is wrong with this?

create function uf_PageTop3
returns varchar(1000)
as
begin
declare @str varchar(1000)

return @str
end

i keep getting the message-
A Return statement with a return value cannot be used in this ccontext

rsshetty.
It's always in the details.

 

[checkai]

just try doing

select @str

 

[rsshetty]

No problem. Just got it.

create function uf_PageTop3() solved it.

rsshetty.
It's always in the details.