Get record based on specific column Sql

Please check you procudure if it is returning result for Rustam

In each procedure i have return for example:

create procedure pinfo

@name varchar(25)

As

If ltrim(rtrim(@name))<>' '

Begin

Select firstname,name,lastname,birthday,address from info where name=@name

Return

End

Firuz says:

Return

 Why you have written it

It's not need here? If it's be mistake can you correct this?

Please refer below code.

SQL

CREATE PROCEDURE pinfo
   @name VARCHAR(25)
AS
IF ltrim(rtrim(@name))<>' '
BEGIN
	SELECT firstname
	      ,name
	      ,lastname
	      ,birthday
	      ,[address]
	FROM info 
	WHERE name=@name
END