DECLARE @name as varchar(50)
SET @name = ''
SELECT * FROM Tabla T
WHERE T.campo = 'valor'

AND T.Name like '%'+ @name + '%'