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

  Scripting using Tableau 9 – Javascript API and Rest API

  April 11, 2015

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

• 0

  IBM Cognos BI Enterprise components

  March 29, 2015

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

• 0

  Export as Excel sheet – Tableau

  December 12, 2014

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