LPAD in SQL Server 2008

by

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.

More Related Contents:

  1. Turning a Comma Separated string into individual rows
  2. Comma separated results in SQL
  3. T-SQL stored procedure that accepts multiple Id values
  4. Understanding PIVOT function in T-SQL
  5. How do I escape a percentage sign in T-SQL?
  6. Using RegEx in SQL Server
  7. How do you count the number of occurrences of a certain substring in a SQL varchar?
  8. SQL Server: Isolation level leaks across pooled connections
  9. Find index of last occurrence of a sub-string using T-SQL
  10. Hidden Features of SQL Server
  11. SQL Server 2008 Empty String vs. Space
  12. EXEC sp_executesql with multiple parameters
  13. SQL Server: combining multiple rows into one row
  14. Query to list all stored procedures
  15. SQL Server: Index columns used in like?
  16. WHERE clause on SQL Server “Text” data type
  17. Return all possible combinations of values on columns in SQL
  18. SQL Server error on update command – “A severe error occurred on the current command”
  19. Recursive sum in tree structure
  20. How to add custom attributes to SQL connection string?
  21. SQL server schema and default schema
  22. SQL to find first non-numeric character in a string
  23. SQL Server – Auto-incrementation that allows UPDATE statements
  24. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  25. How do I remove non-breaking spaces from a column in SQL server?
  26. FOR JSON PATH results in SSMS truncated to 2033 characters
  27. Is there an “IF EXISTS” test for a linked server?
  28. “If not exists” fails on SQL CE
  29. SQL Server stored procedure return code oddity
  30. Generate MD5 hash string with T-SQL

Leave a Comment