Thank you very much for all the replies.

Thanks for the reply. My second post should clarify what I am trying to do.

CREATE TABLE [dbo].[Table_1](

[Col1] [nchar](10) NULL,

[Col2] [nchar](10) NULL,

[Col3] [nchar](10) NULL,

[Col4] [nchar](10) NULL,

[Col5] [nchar](10) NULL

) ON [PRIMARY]

INSERT INTO Table_1

VALUES (1,'AAA','xyq',345,'eyrt'),(2,'CCC','frt',456,'kjhg'),(3,'AAA','kkj',367,'uytr'),(4,'DDD','hhh',543,'fdds'),(5,'CCC','xyt',457,'ewqq'),(6,'AAA','iuy',872,'lkji')

The reult should be:

Col1Col2Col3Col4Col5

1 AAA...