Provide string functions LPAD/RPAD - by Christian C Gräfe

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


9
0
Sign in
to vote
ID 728597 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 3/4/2012 8:10:47 AM
Access Restriction Public

Description

Hello,

it would very useful to provide oracle-like functions for left and right padding of strings.
Oracle has the following function to provide these features.
http://www.techonthenet.com/oracle/functions/lpad.php
http://www.techonthenet.com/oracle/functions/rpad.php

I implemented this feature with T-SQL and CLR,  both ways could not satisfy my performance needs. A implementation in the database engine can provide a much faster performance. Do you agree?

Could you imagine to deliver this feature in the next (maintenance) release of SQL Server?

kind regards
Sign in to post a comment.
Posted by Microsoft on 4/12/2013 at 2:19 PM
Hello,
After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.

Thanks again for providing the product suggestion and continued support for our product.

--
Umachandar, SQL Programmability Team
Posted by Microsoft on 3/7/2012 at 11:17 AM
Hello Christian,
Thanks for your request. We will evaluate feedback on this request and consider it for future.

--
Umachandar, SQL Programmability Team