Sample Function in SQl Server 2005

hi good day everyone, is there any link where we can find the sample how to create function in Sql Server 2005.

example i would like to search that gives me specific person based on the parameter given.

thanks

Here's the doc on how to create function.

http://msdn2.microsoft.com/en-us/library/ms186755(SQL.90).aspx

However, a function may or may not be what you need. How are you going to be invoking and using this?