query help needed

[siddisagar]

Hi Friends, I am having table with below data District Sate Mandal ------- --- ------ Nalgonda AP Nalgona Tirupathi AP Chithoor Output should be District Sate Mandal Address ------- ----- ------ ------- Nalgonda AP Nalgona Nalgonda,AP,Nalgona Tirupathi AP Chithoor Tirupathi,AP,Chithoor Address should be District,Sate,Mandal

[KittyKit]

Check this out http://www.1keydata.com/sql/sql-concatenate.html[^]

[Blue_Boy]

select district,sate,mandal,mandal +','+sate+','+district AS [Address] from myTable

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com