Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jhunu
Starting Member
18 Posts |
 Posted - 2011-12-13 : 12:51:24
|
| What is the funtion used for padding in sql 2005 |
|
|
pnash
Starting Member
26 Posts |
Posted - 2011-12-13 : 12:55:07
|
| this is what you are asking?Replicate ("" ,number )replicate is the function for padding |
 |
|
|
sunnyleoneo
Starting Member
19 Posts |
Posted - 2011-12-13 : 14:29:52
|
| Hi,you are searching for replicate. Please refer http://msdn.microsoft.com/en-us/library/ms174383.aspx.But you need to google if you want to achive left padding and right padding.Please let us know what you want to achieve. Your sample input and desired output. |
|
|
|
|
|
|
What is the funtion used for padding