Returning a varchar from my proc

[Kudel]

I’m trying to return a string from my procedure, but all I get is this message
“Syntax error converting the varchar value my string to a column of data type int.”

Can’t procedures return varchar?

-Kudel

 

[swampBoogie]

The argument to the return statement must be an integer expression.

To return varchar, use an output parameter or a result set.

 

[jdesign]

you can return int value from SP only