IF @Filename LIKE '%.tiff%' PRINT @Filename BEGIN Some code here END
IF @Filename LIKE '%.tiff%' BEGIN PRINT @Filename Some code here END