BEGIN DECLARE @T VARCHAR(20) DECLARE @QRY NVARCHAR(200) SET @T='X' SET @QRY='SELECT * FROM [dbo].[LIBMAST] WHERE CALLNO LIKE %'+@T+'%' EXEC(@QRY) END
var