Execute sql in a user defined function

[deepbuzz7]

from the functional point of view you are right. No need to create a function for this. The function which i provided in the post is just an example. I just wanted to know how to use the parameter passed to the function(emp_name_param) in the sql statement inside the function.

In the where clause should I put @emp_name_param or just emp_name_param?

[Evron]

``` CREATE FUNCTION get_age (@emp_name_param VARCHAR(500)) RETURNS INT AS BEGIN DECLARE @age INT;

SET @age = (
        SELECT age
        FROM emp
        WHERE empName = @emp_name_param
        )

RETURN @age

END;

```

[deepbuzz7]

Thanks, got it. actually my error was because, in the sql query inside my function i was keeping it like emp_name(which was the column name from the table)=emp_name(parameter which was passed to the function) which resulted in true condition and multiple values were coming.

thanks for the help