Merge 3 columns and separate them with dash in SQL Server Query

nedash

I have Datalist in my page that show my users information

and this is my users table

DES3	DES2	DES1	description	address	Name	Id
DES3	DES2	DES1	Des1-Des2-Des3	Paris	Sara	1

I want when users enter DES1,DES2,DES3 it automatically merg this column in DESCRIPTION column .

i want bind description column in my datalist and i want show this column data like this

Des1-Des2-Des3 i want after every word put dash ( - )

how i can do it?

thanks alot

Mudassar

0 1

select id, description, address, Name, (DES1 + '-' + DES2 + '-' + DES3) as DES
FROM table

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html