Re: How do I create a UDF?

Michael -

You need to rearrange some of the code.
The 'Language SQL' statement is in the wrong place.

See below. This worked for me!

- Steve


Create Function myLib/IsNumeric(@TestData VarChar(64))
Returns Char(1)
Language SQL
Deterministic
Not Fenced
Set Option Commit=*None, UsrPrf=*Owner
Begin
Declare @Double Double Not Null Default 0;
Declare Exit Handler For SQLException
Return 'N';
If @TestData Is Null Then
Return 'N';
End If;
Set @Double=Cast(@TestData As Double);
Return 'Y';
End