brief question, i have to create a carrier return for a specific line in a file is this syntax correct;
select a || b || c ||;
also i have 2 sets of social security number which i am pulling from a table. both socials are brought in as
lpad(ssn_id, 11, '00'), lpad(ssn2_id, 11, '00')
now the first lpad brings back 00123456789.
but the second lpad brings back 123-45-6789.
how can i change the second lpad to come back as first, with no dashes and with 0 padding. I tried a like statement but it did not work. please help.