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

  Creating a Donut chart in Tableau

  November 7, 2014

   by Arunkumar Navaneethan · Published November 7, 2014 · Last modified December 1, 2015

• 0

  Tableau URL action

  March 10, 2014

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

• 0

  SQL Server Reporting Service – Introduction

  March 23, 2015

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