{"id":387,"date":"2014-10-29T17:29:41","date_gmt":"2014-10-29T17:29:41","guid":{"rendered":"http:\/\/arunethan.com\/?p=387"},"modified":"2015-12-01T16:28:17","modified_gmt":"2015-12-01T16:28:17","slug":"sql-string-and-number-padded-result","status":"publish","type":"post","link":"http:\/\/arunethan.com\/?p=387","title":{"rendered":"SQL String and number padded result"},"content":{"rendered":"<div class=\"pf-content\"><p>Creating a string and number padded result<\/p>\n<p>&nbsp;<\/p>\n<p>SQL Server right and left padding<\/p>\n<p>select right(replicate(&#8216;0&#8217;,10)+cast(25695 as varchar(15)),10) as lpad_number<\/p>\n<p>select left(cast(25695 as varchar(15))+replicate(&#8216;0&#8217;,10),10) as rpad_number<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Creating a string and number padded result &nbsp; SQL Server right and left padding select right(replicate(&#8216;0&#8217;,10)+cast(25695 as varchar(15)),10) as lpad_number select left(cast(25695 as varchar(15))+replicate(&#8216;0&#8217;,10),10) as rpad_number<\/p>\n","protected":false},"author":1,"featured_media":82,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"link","meta":{"footnotes":""},"categories":[105],"tags":[15,62],"_links":{"self":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/387"}],"collection":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=387"}],"version-history":[{"count":2,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/387\/revisions"}],"predecessor-version":[{"id":389,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/387\/revisions\/389"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/media\/82"}],"wp:attachment":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=387"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}