DECLARE @Lookfor varchar(10) SET @Lookfor ='i' IF 'My string' LIKE '%' + @Lookfor + '%' PRINT 'Found ' + @Lookfor