----NOTE I AM USING SQL 2008 R2
DECLARE @S VARCHAR(MAX)
SET @S = 'LP MEN'
;WITH CTE AS
(
SELECT DISTINCT ID,
Brand+','+Gender+','+Product+','+ProductType+','+CONVERT(VARCHAR,Size) as ProductDescription,
Brand+' '+Gender+' '+Product+' '+ProductType+' '+CONVERT(VARCHAR,Size) AS SerchProduct
FROM [dbo].[Test]
)
SELECT *
FROM CTE
WHERE SerchProduct LIKE '%'+@S+'%'
----------------OUTPUT-----------------
--1 LP,Men,Shirt,Formal,40 LP Men Shirt Formal 40
--2 LP,Men,Pant,Formal,30 LP Men Pant Formal 30
Yogesh Bhadauriya
Sr Technical Lead
Ahmedabad, India
Star
10303 Points
2360 Posts
Re: How to filter multiple columns based on single criteria in sql
Apr 06, 2019 04:35 AM|yrb.yogi|LINK
Use below query to get output
Sr Technical Lead
Ahmedabad, India