Add "-" instead of spaces in select

Question

Is there a way to add the "-" carector instead of speces in the below column in my select statement:

SPACE(([Depth]-1)*4) + [OrgUnitName] AS [OrgUnitName],

So right now it adds spaces for however many depths there are. Is it possible to have this add the "-" charector instead of the spaces? The data is locations so it could have spaces between the words as well.

So for:

Test
 Test2
  Test23

I want:

Test
-Test2
--Test23

Albin Sunnanbo · Accepted Answer · 2012-09-14 18:48:52Z

3

From the documentation of REPLICATE:

REPLICATE ( string_expression ,integer_expression )

That is

REPLICATE ('-', ([Depth]-1)*4) + [OrgUnitName] AS [OrgUnitName],

in your case.

However I prefer to return Depth as an output column and format the dashes with code. As little formatting and logic as possible in the SQL queries increases maintainability in my experience.

answered Sep 14, 2012 at 18:48

Albin Sunnanbo

47.2k8 gold badges72 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add "-" instead of spaces in select

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related