I need to concatenate from 7 different columns of a table with hyphen between text from each column.

In few cases where columns have nulls,
I get string like; `--Account--stands---`

The desired output is `Account-stands`. Please help.

Regards,
Sajan