Reading zero postgres, sql server, bss strategic

postgres

---------------------------------------------------------------------------
https://w3resource.com/PostgreSQL/lpad-function.php

SELECT lpad('esource', 13, 'w3r');

 lpad
---------------
 w3rw3resource
(1 row)

----------------------------------

SQL SERVER

select
len('TK_ST1234')





select
substring('TK_ST1234',4,100)





select
right(substring('TK_ST1234',4,100),11)





select
right('00000000000'+right(substring('TK_ST1234',4,100),11),11)





select
'1002'+right('00000000000'+right(substring('TK_ST1234',4,100),11),11)






select
len( 
'1002'+right('00000000000'+right(substring('TK_ST1234',4,100),11),11))
















postgres 




tunai_kita







query


selectlpad(right(substring('TK001A2',3,100),11),11,'00000000000');


Result
lpad
000000001A2

Tweet