Create function in SQL

I need a simple SQL program demonstrating the use of CREATE FUNCTION command in SQL. A create table can be used to generate a simple record of items such as name, title, age. The Create Function command will be used to retrieve one specific value.

The program should demonstrate and show how you can pass a variable in and output a variable.  Anything that would demonstrate this concept would be great. I am open to any ideas.