I have a SQL function in DB server?

Question

Hi All,

I have a SQL function in DB server created for padding with string with int. i have an identity int field in DB.

My question is. how to get this identity field to pass to SQL Function where it padds and return string as <string>+<identity field> and display in front end. i want to know the logic.?

Main thing is..i have sqlcommand class where i have writen insert query excluding identity field.
question lies is how to pass the identity field to sql and padd to string and return the value and dispaly in VB/C#?

whether Direction in C# to be used for input/output parameter.?

Any suggestions or Ideas plese suggest to me..

thanks
Raghu