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 ()
- MySQL
- DB2
- Informix

20 votes
Sign in
(thinking…)
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.

0 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base