build dynamic string efficiently tsql

Question

I need to build a string in tsql which is a repetition of a given char for example if I have inputs

@in char,@len int

and in = 'x' ,len = 7 the result will be

xxxxxxx

Answer 1

Try this:

select replicate(@in,@len)