
use control

IF OBJECT_ID('NV_ConvertIntToString') IS NOT NULL
  DROP PROCEDURE NV_ConvertIntToString
GO


CREATE PROCEDURE NV_ConvertIntToString 
	@intValue integer, @vchValue varchar(200) OUTPUT
AS

IF ( @intValue = null )
	SELECT @vchValue = 'null'
ELSE
	SELECT @vchValue = CAST(@intValue AS VARCHAR(200))

RETURN