Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

provide lpad/rpad funtion

In 15 years of sql server development, was the lack of native lpad/rpad string funtions, one of the main pain. Please provide native left padding (lpad) and right padding (rpad) funtions.
Every main DBMS supports this function, except MS SQL Server.
I think this an easy subject that has to be changed.

The follwolling DBMS supports rpad/lpad:
- Oracle
- Postgresql ()
- DB2
- Informix

20 votes
Sign in
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

Upvotes: 1

<=-=May 29 2017 1:07PM=-=>

Thanks you for the idea. We will keep it into the backlog but we cannot guarantee when it would be implemented. We have already added several new string functions STRING_AGG, TRIM, TRANSLATE, and it would be good to add more. We are prioritizing functions that might be added so we cannot confirm when we will add this one.


Sign in
Sign in with: Microsoft
Signed in as (Sign out)

Feedback and Knowledge Base