Hello All,

Is there a mechanism in Sybase equivalent to functions in Oracle. I wan to create a function in sybase which executes a routine (repetetive) code. I want to run each record from a table through a bunch of validations in T-SQL. Whenever a validation fails , i want to insert this record into a table. I dont want to add insert into code after each validation failure but instead want to call some sort of a function. Calling another stored proc is an option but would like to know if there is another efficient way of doing this. There are about 100k records to be processed.