How can I create a user defined function

[Dark_Omen]

Hello,

Can anyone explain to me how I can create a function that I can use in SQL.

Thanks

[nicentral]

It's pretty easy.

CREATE FUNCTION MyFunction(@variableOne datatype)
RETURNS datatype
AS
BEGIN

-- put function logic here

RETURN @variable

END

Then to call the function, you would use it in any SQL statement. For example

SELECT FIELD1, MyFunction(FIELD2) as ALIAS
FROM SOMETABLE;

Hope this helps

Andy

[Dark_Omen]

Thanks, that was very helpful