Is there a way to pad the front and back of strings with spaces?

NOTE: I do not want to concatenate with a fixed string, Im looking for a function something like where you can input a number and a string and the string will be repeated that many times

thanks

I think you are going to have to write your own UDF to accomplish that.

If it was just padding on the back, you would just cast/change it to a char

Andy

I guess you are looking for a function like REPEAT

Refer the documentation to make sure this suits your requirements

Sathyaram