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:
- Postgresql ()
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.