Thank you very much i was racking my brains and it all clicks now.

Thank you again.

:-):-):-):-):-):-)

So created this test table for people to help me on.

Here is the code.

[Code]

CREATE TABLE dbo.TEST_TABLE2(

[REF_NO] [int] NULL,

[TITLE] [varchar](max) NULL

) ON [PRIMARY]

INSERT INTO dbo.TEST_TABLE2

Values (25995, 'Outlook') ;

INSERT INTO dbo.TEST_TABLE2

Values (25995,...

Not sure what DDL info you need

Here is some sample Data

REF_NOTITLE

25995bsdinfg0503.eu.ad.espeed.com

25995ESSHQSM01.eu.ad.espeed.com

25995ukqsmweb01.eu.ad.espeed.com

26237ukesp024.eu.ad.espeed.com

26237ukqsmweb01.eu.ad.espeed.com

26258ukqsmweb01.eu.ad.espeed.com

26267esshcddc03.eu.ad.espeed.com

26267ukqsmweb01.eu.ad.espeed.com

26872ukesp024.eu.ad.espeed.com

45287ukesp024.eu.ad.espeed.com

I would like it to read.

REF_NOTITLE

25995bsdinfg0503.eu.ad.espeed.com, ESSHQSM01.eu.ad.espeed.com, ukqsmweb01.eu.ad.espeed.com

26237ukesp024.eu.ad.espeed.com, ukqsmweb01.eu.ad.espeed.com

26258ukqsmweb01.eu.ad.espeed.com

26267esshcddc03.eu.ad.espeed.com, ukqsmweb01.eu.ad.espeed.com

26872ukesp024.eu.ad.espeed.com

45287ukesp024.eu.ad.espeed.com

Not sure if this helps. The code in my previous replies...

also used this and it produces the same.

SELECT DISTINCT REF_NO,

...

I have tried 2 different ways now and each data row comes out with the exact same data in. It seems to be picking up the all the 'TITLE'...