thank you guys for your replies and for some logics, i need the null values to be returned.  the answer provided by 

June 9, 2018 at 9:47 am

#1993484

Thank you Eric and wonderful. i did not know that we can apply MAX operator for  strings. Good learning today. appreciated your swift response.

Thank you guys for the reply and have one  tiny question. 
Is there any way to include the shop name when shopped only at one shop, expected answer:
[code...

thank you. it worked

Thank you scott for  sharing another way of doing this.

Hi Drew,

below is my try
DECLARE @EndDate DATETIME
    ,@StartDate DATETIME
    ,@Duration TINYINT = 15;

SET @EndDate = getdate();
SET @StartDate = DATEADD(MM, - @Duration,...

Hi Drew,
Thank you and it's working. is it possible to pass the 24 as value?...

Hi Chris and Jeff thank you for the replies. i will hold these values in temp table and will be using it for further use  in joining with other tables....

thank you steve for the reply. i will first do that and  get back to this

Thank you John and your solution perfectly worked for me. much appreciated.

Hi Tom,
Let it be empty with comma for last row like this   111,200,201,202,,,
Is it possible to do? any sample query please

Thank you for the inputs Luis. i will go through throughtly

Hi Luis,

As you suggested i have tried to download the adventure database and found the below stored procedure has the logic of search. but look like sqlserver fulltext...

Hi Luis,

Thank you for the reply and  I just checked the ProductCompleteDescription has 4000 characters limit. not varchar(max)

Also, you mean to say index will not help...