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

  Scorecard Vs Dashboard (Business Intelligence)

  April 2, 2015

   by Arunkumar Navaneethan · Published April 2, 2015 · Last modified December 1, 2015

• 0

  Dynamic sorting with Tableau

  November 10, 2014

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

• 0

  Webpages and URL action – Tableau

  December 1, 2015

   by Arunkumar Navaneethan · Published December 1, 2015