stuff or pad spaces to the left

*MSSQL*

create view vuecollectionsummaryor
as
select ornumber,

ornumberstr =

convert(
char(20),
space(20 - len(ornumber))
+ ornumber),

datecollected,


collection
from collectionsummaryor


*POSTGRESQL*

create view vuecollectionsummaryor
as
select ornumber,

-- ornumberstr =

lpad(ornumber,20) as ordernumberstr,

datecollected,


collection
from collectionsummaryor