Insert space and number(Padding in SQL)

Question

Hi I used this Insert data from dataGridView itrsquos worked but I want insert space with number into database IdSeparateNumber120160330   1220160330   2320160330   3420160330   4520160330   5620160330   5720160330   3820160330   1920160330   21020160330   31120160330   41220160330   5For example if id length  1 then before number need threespace    1  if id length  2 then before number need two space   10  if id length  3 then before number need two space

Shashikant · Accepted Answer

HiPlease refer below sqlSQLDECLARE Id VARCHAR50SET Id  1SELECT Id  REPLACESTRId 3 SPACE1 39039 SELECT IdSELECT Id  REPLACESTRId 3 SPACE1 39 39 SELECT IdHere I have shown for 0 and space as wellOutput001

Id	Separate	Number
1	2016_03_30	1
2	2016_03_30	2
3	2016_03_30	3
4	2016_03_30	4
5	2016_03_30	5
6	2016_03_30	5
7	2016_03_30	3
8	2016_03_30	1
9	2016_03_30	2
10	2016_03_30	3
11	2016_03_30	4
12	2016_03_30	5

Insert space and number(Padding in SQL)

Hi! I used this Insert data from dataGridView

Company

Explore

Follow us

Contact Us