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.
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?