Thanks Naomi
regards,
Gerard


>>I have a scalar User Function which Takes in Two Integer Parameters, and returns one Integer
>>Is there a way of testing the function in SSMS (without having to put it into a select Statement)
>>i.e. I just want to run the Function with the two paraneters
>>Tia
>>Gerard
>

>select dbo.ScalarFunction (@Param1, @Param2)
>
>-- alternatively
>declare @Result int
>execute @Result = dbo.ScalarFunction @Param1, @Param2
>
>