sql-servert-sql

LPAD in SQL Server 2008

I can't see a function like LPAD in SQL Server 2008. For example how can I convert the following queries into T-SQL?

select  LPAD(MY_VALUE,2,' ')) VALUE
FROM MY_TABLE
Solution

  • Basically pad it with the number of characters you are intending to select and then right the string.

    Select right(replicate(' ',2) + YourFieldValue,2) from YourTable

    You can use the space function instead of replicate, space(number_of_spaces), replicate just allows you to pad with alternative characters.