Hi

I have created a function. it created successfully. But when i want to use it, then it gives some error message : 'func3' is not a recognized function name.

step 1

create function func3 (@p1 int,@p2 int)
returns int
as
begin
return @p1 * @p2
end

step 2

Select func3(5,6) as result

or

declare @x int
Set @x=func3(5,6)
print @x

Thanks in advance
Kumar Ashish
[email protected]

__________________
Thanks
Kumar Ashish
[email protected]

Try to prefix the function call with the schema name, probably "dbo." then calling "dbo.fname(x,y)"

Palli