You can use a Function in SQL to return a value as a part of the select statement. The procedure will not return as a part of the select statement.