Hi,

Functions are best suited for my requirement. I use the value returned by a scalar user defined function as a part of

insert into t1 select *, function_f1() from t2.

i cannot use a stored procedure here. however, there is a business validation that I want to do inside the function for which I will have to throw an exception / error.

Please let me know if there is any method to do this or any work around for this...

Thanks,

Roopa.