GO
/****** Object: UserDefinedFunction [dbo].[GetX] Script Date: 09/28/2012 10:38:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create FUNCTION [dbo].[GetX](@X integer,@ImageNO integer)
RETURNS varchar(500) AS
BEGIN
declare @value varchar(500)
select @value=cast(X as int)+@X from t_Items where ItemID=@ImageNO
return @value
END