Stored Procedure Return Parameter

[testeng]

I am trying to return the @@Identity field from a stored procedure after a row is inserted but I keep getting an error that it can not convert it to a integer error. I have returned parameters before but always an integer value what is the trick to returning a string?

Thanks is advance

 

[Sheco]

Did you get the error using CAST or CONVERT functions?

Show us the line from your sp.