SQL String and number padded result

by Arunkumar Navaneethan · Published October 29, 2014 · Updated December 1, 2015

String and number padded result →

Creating a string and number padded result

 

SQL Server right and left padding

select right(replicate(‘0’,10)+cast(25695 as varchar(15)),10) as lpad_number

select left(cast(25695 as varchar(15))+replicate(‘0’,10),10) as rpad_number

Tags: SQLsql server

You may also like...

• 0

  SQL Server Reporting Service – Introduction

  March 23, 2015

   by Arunkumar Navaneethan · Published March 23, 2015 · Last modified December 1, 2015

• 0

  IBM Smarter Analytics approach

  March 28, 2015

   by Arunkumar Navaneethan · Published March 28, 2015 · Last modified December 1, 2015

• 0

  Tableau filter excluding All

  March 5, 2014

   by Arunkumar Navaneethan · Published March 5, 2014 · Last modified December 1, 2015