ASE does not support user-defined function in pure SQL yet. However, you can
achieve the effect you want by creating a Java class and mapping a function
to it. See www.sypron.nl/udf.html for examples.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"uttamrao" <u18040@uwe> wrote in message news:5adb1435613bc@uwe...
> I have to use a stored procedure in one of my sql statement
> e.g.
> UPDATE tbTable
> SET fdField1 = myProc ( fdField2, fdField3)
> WHERE
> fdField4=someval
>
> its giving error as sybase allows only built in functions here.
>
> It was possbile in oracle by creating a function.
> Any help? Any workarounds?