Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Returning a sting from a Stored Procedure

Author  Topic  Andy Starting Member 6 Posts Posted - 2001-02-13 : 17:10:51 I'm having trouble trying to return a string from a stored procedure, heres what i have so far. CREATE PROCEDURE [Get_ClientType] ( @Tag int, @Description nvarhcar(10) OUTPUT ) AS @Description = SELECT Description FROM ClientType WHERE Tag = @Tag ClientType.Description is a nvarchar(10) field and instead of returning a whole recordset containing 1 string, i just want to return the string. I'm getting an incorrect syntax near @Description