No, you cannot do that but you can use UDF (SQL 2000) or a trigger.
>Hi folks
>
>Is it possible to fire off a stored procedure (which returns a value) in insert query to be used as 1 of the values to be saved to the table ?
>
>I've tried various syntax but can't seem to get it to work.
>
>Regards
>
>Kal
--sb--